Post reply

combine rows into one row

  • January 10, 2020 at 7:38 pm

    #3714548

    Not sure if this is possible . . . .

  • January 10, 2020 at 8:06 pm

    #3714561

    I believe i need to use STUFF and/or XML functions but get lost in the weeds.

  • January 10, 2020 at 9:35 pm

    #3714582 

    CREATE TABLE #d(
     HTS_NUM CHAR(4),
     Ctry CHAR(2),
     GA_REQ_CODE CHAR(3)
     );
    GO
    INSERT INTO #d VALUES ('1062','US','FD3'),('1062','US','FW2'),('1062','US','FD3');
    SELECT DISTINCT HTS_NUM
     , Ctry
     ,stuff((
        SELECT ', ' + cast(GA_REQ_CODE as varchar(max))
        FROM #d
        FOR XML PATH('')
        ), 1, 2, '') AS lst
    FROM #d
    ORDER BY HTS_Num, Ctry;

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

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