Post reply

getting column names for table using query

  • June 16, 2005 at 1:20 pm

    #566245

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







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

  • June 16, 2005 at 1:22 pm

    #566247

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







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

  • June 16, 2005 at 1:22 pm

    #566246

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

  • June 16, 2005 at 1:23 pm

    #566248

    You'd never do that, would you??

  • June 16, 2005 at 1:29 pm

    #566250

    jamais!!!!

    <;-)







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

  • June 16, 2005 at 2:43 pm

    #566258

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

    Regards,
    gova

  • June 16, 2005 at 10:11 pm

    #566298

    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