Post reply

Merging the rows

  • November 19, 2012 at 2:13 am

    #284973

    The Output result set is coming as

    Column

    -------------------------

    a-1 (row 1)

    b-91e25b15-(row 2)

    c-66364531(row 3)

    expected output required(all rows needs to merged into single row)

    a-1 b-91e25b15 c-66364531(row 1)

  • November 19, 2012 at 2:24 am

    #1560225

    try this

    declare @sql varchar(max)

    select @sql=coalesce(@sql,'')+columnname

    from

    tablename

    select @sql

  • November 19, 2012 at 3:13 am

    #1560247

    Thank you

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

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