Post reply

Col to Row without temp table

  • October 21, 2008 at 10:47 pm

    #70838

    Hi experts !

    Query

    Select cityname from city

    Result

    Cityname

    citya

    cityb

    cityc

    and so on....

    Required result

    Cityname

    citya,cityb,cityc,and so on...

    Thanks in advance.

  • October 22, 2008 at 12:14 am

    #887956

    I'm using SQL Server 2000 !

    Thanks a lot for the reply. This will work for me.

    🙂

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

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