See below (quoted).

Bridge burning:

Your self-proclaimed "Senior Systems Analyst / DBA", a previously self-proclaimed "Senior System Ananlyst" in his email signature to everyone in the company, who continually demonstrates intellectual laziness, who has...

Is there any reason not to avoid using dynamic SQL here? Performance? Elimination of subqueries/joins (no joins in your example)?

Running the select with conditional comparisons produces the same...

I have not reported it. From briefly perusing the several thousand results on Connect for SQL Server and "csv", the standard cop-out for this issue seems to be "use...

SSMS 2012, results to grid, with the option to quote values containing the column delimiter. Why one wouldn't want to do that, among other things, is beyond me:

select

','

,'"'

,'

'

,',"

'

Surely, this is...

CSV support in SSMS (saving result sets as...) is deliberately broken. Gee, I wonder why.

Craig Farrell (4/14/2011)

Huh? Could you specifically quote where...

I get it: "then", "than", "there's", "there are". Stop reading (and I did), it can't be coherent.