i m importing one flat file to sql server ...in that flat file one column is showing as string ..whn i m importing to sql server i m taking it as nvarchar...Data is ok ..
But whn i do some actions like sum ..if there is null in sql server it is show as value+null as valuenull...(it is taking null as string not as null into sql server)
output like (when do sum)
How to proceed for this.
View Complete Post