Prev: Remove word from end of string
Next: Selecting from a table where my unique Key is not their uniquekey.
From: Jim in Arizona on 22 Jul 2008 13:48
"Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message
news:84888042-E96A-4F84-AA4D-62240AB49ED8(a)microsoft.com...
> Add WITH ROLLUP after the GROUP BY clause and it will add the summary row.
> In the SELECT list you can use the GROUPING function to check if the row
> has been added by ROLLUP and replace NULL with 'Total' or something else.
>
> HTH,
>
> Plamen Ratchev
> http://www.SQLStudio.com

Cool!!
Thanks again Plamen!


 | 
Pages: 1
Prev: Remove word from end of string
Next: Selecting from a table where my unique Key is not their uniquekey.