Good day, i need help please.
The problem i have is that a percentage colume in my table, when i sum the total = '100.0000000'
This fine, but when i insert in SSIS - Lookup & i preview the data in Lookup task the Total = '100.072' which makes my calculations incorrect.
is there something i need to do to keep it in its original sum - but i view my decimal places in advanced properties decmal(38,12) so this should be fine.
Is in the query that i have to perhaps force it to be 100.0000, how?
Can somebody please direct me on what i should do
View Complete Post