Hi,

It would be so grateful if anyone can help me on the below issue.

I am using an SQL string to extract the data from SQL server, here I
have to sort the data in excel exactly like when we are using "with
rollup" in SQL (or like pivot table in excel, but this is very
difficult for my project).

My query look like this:
SqlStr = "Select Distinct LOB,THIRDPARTY_FLAG,LANGUAGE,CENTRE_NAME
From scorecard" & _
" Where LOB = 'BILLING'" & _
" group By LOB,THIRDPARTY_FLAG,LANGUAGE,CENTRE_NAME
with rollup"

but when I'm using this, I am getting below error:

Run-time error '-2147217900 (80040e14)':
Incorrect syntax near the keyword 'with'. If this statement is a
common table expresssion or an xmlnamesspaces clause, the previous
statement must be terminated with a semicolon.



Many thanks in advance.
Ratheesh