Post reply

Can we merge two column FROM TWO ROWS?

  • April 17, 2009 at 12:03 am

    #131295

    Dear friends,

    I need to merge two column when i use select query example...

    My table having..

    code name

    1 sara

    1 Jhon

    2 ram

    2 rahim

    select code,name from detail where id = 1

    O/P is

    1 sara

    1 jhon

    but i need to Show with single row

    O.p should be..

    1 sara/Jhon

    Any possible to merge two records?

    Please Help me..

    Very Urgent..

  • April 17, 2009 at 1:36 am

    #979451

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic699124-8-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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