Transact-SQL (TSQL) is the extended SQL dialect used in Microsoft SQL Server and Sybase

learn more… | top users | synonyms

1
vote
1answer
70 views

Sql query to obtain totals and subtotals

I'm interested in knowing if there's a better/cleaner/more efficient way, to obtain totals and subtotals within a query, than my solution below. The query works fine but I'm just intrigued to know if ...