August 17, 2009 at 10:32 am
how to get your results from a query into xls With field headers?
August 17, 2009 at 10:37 am
if you mean when you copy and paste from Management Studio to Excel, it's an option you'll want to turn on:
did you mean something else?
Lowell
August 17, 2009 at 10:41 am
Yes
August 17, 2009 at 10:49 am
Yes = You meant something else?
or
Yes = That was the solution i was looking for?
Lowell
October 28, 2009 at 5:33 pm
You could do something like this:
Select 'Name' As myColumn1, 'Address' As myColumn2
Union
Select myColumn1, myColumn2
From myTable
Where blah, blah
Basically the first query is just doing a SELECT of all the column names in the underlying table.
October 29, 2009 at 7:05 am
If you can get your hands on the 2008 tools there is a Copy With Headers option in the right-click context menu.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 29, 2009 at 7:27 am
I did not ask this question but thanks for this. It was on my ' I wonder where that is. I must make time to look.......' list
Madame Artois
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy