Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Concatenating Rows

    Another option is:

    DECLARE @FruitList NVARCHAR(max)

    with

    fruit as (

    select 'Apple' as name, 101 as id union all

    select 'Banana' as name, 102 as id union...

Viewing post 1 (of 1 total)