Thanks. I have probably stumbled onto a version of one of the methods before, but I appreciate your taking the time to write it down so others can keep it on file.
I think Microsoft must have heard this request a million times, because Management Studio in SQL Server 2005 has the option "Include column headers when copying or saving the results." That one checkbox would save a lot of grief in Query Analyzer.
🙂
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html