Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: Append column data

    I am using SQL Server 2005.

    My query in the stored procedure retuns some thing like this.
    Num Code_1 Code_2
    1 1230 A12
    1 1230 C13
    1 1230 B14
    2 1230 R115
    3 1234 A12
    3 1234 A13
    4 1124 NULL

    I need to conacatenete code_2 data by Num as below.

    Num Code_1 Code_2
    1 1230 A12,C13,B14
    2 1230 R115
    3 1234 A12,A13
    4 1124 NULL


    Can any one help me. It is urgent. Thank you in advance.

  2. #2
    Join Date
    Jul 2011
    Location
    India
    Posts
    13

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •