convert Row into Column with Comm separete in Sql Server

 

Table structure :  tbl_Payment

PaymentID varchar no 12
dt datetime no 8
RegistrationId varchar no 50
Payamt numeric no 9
Paymode char no 100

 

 

SELECT

DISTINCT right((SELECT (',' + paymentid) FROM tbl_Payment

WHERE

registrationid = T .registrationid FOR XML PATH('')),len((SELECT (',' + paymentid)

FROM

tbl_Payment

WHERE

registrationid = T .registrationid FOR XML PATH('')))-1)

FROM

tbl_Paymen T

 

OUTPUT :

PR000182,PR000191
PR000183,PR000192
PR000194
PR000202
PR000203
PR000206
PR000207,PR000208