My recommendation would be to do this using SSIS (or the Import/Export Wizard). you can easily output the result of a query to EXCEL through SSIS, save the SSIS package...

Yes but as dwain.c mentioned, it will get you the intermediate results which you can simply concatenate to produce the final results. (have the Pivot in a CTE and concatenate...

Hmm am not so sure where exactly you are having the bother, and whether its to do with getting the percentage numbers, or formatting the cell as a percent, but...

I would say your best bet other than using that Adapter is to either:

> As suggested earlier, just grab the data from the DB, I have done that before and...

Hmm, there might be plenty of reasons, but here are a couple to get you started:

> When you are submitting your Linq-to-SQL DataContext (through the SubmitChanges method), are you scoping...

I think thats due to the ROWTERMINATOR parameter not being supplied to the BULK INSERT procedure. (probably because WYSIWYG not displaying the character \ n)

Try something like:

BULK INSERT [Thesaurus] FROM...

You are a genius!!

That article made A LOT of sense, in terms of whats actually happening in the background as well as how to get around the issue.

Thank you very...

Aye separating the query seems to be the way forward, although it just feels "dirty". I mean we're talking 11 reporting queries, each will have 3 ISNULL parameters, thats 33...