Hello,
We're using SQL Server 2000 and Query Manager (not Visual Studio). When your query results are returned, the column names are displayed at the top, but this information is NOT available for cut/paste to Excel. One of the workarounds we thought of was to return the column names within the query itself, and thought there was perhaps an option or other feature of SQL Server that would allow us to put the column headings into Excel without...

Thanks, this is a MUCH more workable solution!...

Thanks Jim. This works, although I was hoping that the answer wouldn't involve having to parse the string returned by the function (I need to have these values available for loading into another table). Any other ideas out there?...

My problem is as follows:
I have a customer table and an address table. A customer can have 0, 1 or many addresses. The query result I'm trying to get produces 1 and only 1 row for each customer, with either 1 address or null's for the appropriate address fields. Here's some simple sql to demonstrate:

create table test_customer (custid char(10), custname char(20))
create table test_address (custid char(10), addrid char(10),...