Post reply

rows to columns in sql 2000

  • January 16, 2008 at 3:18 am

    #127510

    I have a countrymaster table in my database sql 2000

    If I do

    select * from countrymaster

    then I get list of all countries rowwise in the output, but I want to get the ouput columnwise, how can I do this

    example instead of

    USA

    UK

    France

    Canada

    I want output as

    USA UK France Canada

    Pls help, thanks

  • January 16, 2008 at 6:37 am

    #768605

    Your problem is purely one of presentation. You may be able to use a cursor to build a single-string result-set, but then Jeff Moden will not be very pleased. What front-end tool are you using?

    Regards,

    goodguy

    Experience is a bad teacher whose exams precede its lessons

Viewing 2 posts - 1 through 1 (of 1 total)

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