Post reply

Concat Column of multiple records

  • April 26, 2022 at 5:28 am

    #4022234

    Hi

    I want if multiple records are returned by inner query then Docno of all records should get concatenated with comma separation.

     

    Select T1.Itemcode,T1.name ,(select docno from order where id = T0.id)

    from tbl1 T0 inner join tbl2 on T0.itemcode = t1.itemcode

    Thanks

  • April 27, 2022 at 6:10 am

    #4022835

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • April 27, 2022 at 3:23 pm

    #4023104

    STRING_AGG() is your friend

  • April 27, 2022 at 3:30 pm

    #4023106

    STRING_AGG isn't available before SQL 2016, right?

    Select T1.Itemcode,T1.name ,
        stuff((select ', ' + docno 
            from [order] o 
            where o.id = T0.id 
            order by docno
            for xml path(''), type).value('.', 'varchar(8000)'), 1, 2, '') as docnos
    from tbl1 T0 
    inner join tbl2 on T0.itemcode = t1.itemcode

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

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

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