getting column names for table using query

  • Any idea why I'm not able to get the columns in row format ???







    **ASCII stupid question, get a stupid ANSI !!!**

  • I COMPLETELY misunderstood the original post....sorry - I take back all my stupid questions!







    **ASCII stupid question, get a stupid ANSI !!!**

  • No, I don't know that trick... I usually just copy/paste the whole thing directly and it works.

  • You'd never do that, would you??

  • jamais!!!!

    <;-)







    **ASCII stupid question, get a stupid ANSI !!!**

  • Sorry I was away. Like Mike mentioned once the people who gives pay-check wants me also to work. Now all answered.

    Regards,
    gova

  • Guys, grab a hold of SQL2K5, using Management Studio, set your options for the Query Results to Grid and Text options to be 'include column headings when copying from query results' so then when you copy|paste from query to excel, across come the column names as required.  No code, no hassles

     

    Steve.

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply