hi all
i m using sql server 2005. i m using rollup query to get total sum and sum with group within single query. it shows me total amount but with null field . i want to change this null field with "total " caption.
pls suggest how this thing is possible.
thanks and regards
Ganesh
Moved to t-sql forum...|||That is the way a Rollup query works, and, unfortunately, as far as I know, there is no way to get around it.
Of course, your client side application could easily do that. (After all, presentation is the point of client applications, data storage and retrieval is the point of SQL Server.)
|||Use the GROUPING function in the SELECT list like:
CASE GROUPING(col1) WHEN 1 THEN 'Total' ELSE Col1 END
See Books Online for more details. Or post your sample query here to get the corrected one.
|||Good Idea Umachardar, I consider it, but discarded the idea since it didn't quite seem to fit the OP's request. But perhaps it will.