Wednesday, March 28, 2012

Grouping on ISNULL SP

I use the folliowing SP in a report in which i group by categorydescription:

SELECT ISNULL(categorydescription,'No category indicator code') as categorydescription, AccountMV, AccountFeeLY, ISNULL(company,'other') from snapsraw
where branchstate = @.state and (monthend = @.date)

problem is it doesnt show the isnull value for categorydescription in the group table, its just blank?

nevermind, doesntshow up in VS, but shows up on websql

No comments:

Post a Comment