Can we merge two column?

Question

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

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

Anam Verma SSCertifiable Points: 5365 More actions · Answer 1

in a rush but will give a sample code and you can work around it based on your requirement.

DECLARE @colList varchar(8000)

SELECT @colList = COALESCE(@colList + ', ', '') + tblcol

FROM test

WHERE id = 3193

SELECT @colList

Saravanan_tvr SSCarpal Tunnel Points: 4558 More actions · Answer 2

THANKS FOR YOUR REPLY..................THANKS SO MUCHHHH

j nuñez SSCrazy Points: 2175 More actions · Answer 3

If you need to expand this solution to a set of record, you can view this article, to see another interesting ways: