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