I hate to point it out because the OP has done a lot of nice SP work for this and has a GREAT documentation header, albeit some very minor typos.

but...

I ran this on a sql2008 db (compat level 100), but it gives an error (below). Does the script need an update?

Exec [ExportObjectToCommaDelimitedCSV] 'dbo', 'my_table_name', 'C:\temp\tblexport.txt', null, 0

Msg 16950, Level...

I'm glad other folks are seeing the logical issue with the answers too. I almost blew my lid when it said D was incorrect. that's bs

😀

Great article, Chuck. Can you update it as the other poster (kevriley) found this too?

I did want to add additional info on something though. When you say "No they do...

One thing to keep in mind about using the dll method is that you may run into performance problems, especially in matrix cell formatting, as the call seems to be...

This is possible in sql 2000 as well.

select 1 as id, '1st' as position into #data union all

select 1 as id, '2nd' as position union all

select 1 as id, '3rd'...