Are looking to give some extra context to your SQL query output before you deliver to business users WITHOUT the use of Excel?

A colleague of yours would like to see the sales per person including a GRAND TOTAL row. Using GROUP BY ROLLUP ( ColumnName ) you can easily create this, But this will leave an ugly blank, as a description for the grand total row. Yuck! Luckily this is easily fixed by adding a simple CASE WHEN to your code.

Below is an example.  

SELECT
	 case 
		when grouping(Person) = 1 then 'GrandTotalRecords'
		else Person
	 end as Person
	,count(*) as TotalRecords
FROM [TEST].[dbo].[SimpelAantalPerPersoon]
group by rollup(Person)
order by Person