Viewing 12 posts - 1 through 12 (of 12 total)
Kingston and Chris: many thanks for your responses - absolutely awesome. The level of help offered in these forums is quite extraordinary.
Gayathri: did the responses offered by Kingston and Chris...
July 14, 2010 at 9:11 am
Thanks for this thought. I'm just off for a week's holiday so haven't had / got time to think this through, but can I tie a trigger in to my...
July 3, 2009 at 9:15 am
Thanks very much for your suggestion - it works a treat! One less thing to think about over the weekend.
I did wonder if the problem was that the row...
February 20, 2009 at 10:01 am
Warning! Brian does point out that this technique may be no good if the file name needs to be known at a later stage in the package becuase the time...
September 18, 2008 at 1:30 am
I hear what you are saying, but if someone can't get column headers into Excel by following the technique published in the August 2004 edition of SQL Server Magazine (InstantDoc...
October 27, 2005 at 12:38 am
I can't believe you posted this
The whole point of the article was to get column headers in.
October 26, 2005 at 6:43 am
It could be that I'm really tired (and I am), but step 3 of Method 1 says:
Click "Results in Text"
So we're no longer in "Grid" mode. The article...
October 26, 2005 at 3:41 am
"Now if the article had really told me how to cut and paste the grid results into Excel - with the header row"
But it did...
"It's perfectly natural to export to...
October 26, 2005 at 2:15 am
Why do you use such a long-winded way? If you have Results output format as Tab Delimited you can just paste straight into Excel and each column of the query...
October 26, 2005 at 2:02 am
"The Best Kept Secret About SQL Query Analyzer"
Er, wasn't this technique published in the August 2004 edition of SQL Server Magazine (InstantDoc ID 43115)?
October 26, 2005 at 1:20 am
When I try to access a video I get the following error:
/howto/viewhowto.asp, line 21
December 16, 2004 at 12:45 am
I too use this technique from time to time - it's a neat trick that has all sorts of uses. One slight improvement that takes possibly less effort is...
July 8, 2004 at 1:01 am