Friday, September 4, 2009

Convert Columns into Row with Comma separe 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
 
 Query :

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_Payment 
OUTPUT :
PR000182,PR000191
PR000183,PR000192
PR000194
PR000202
PR000203
PR000206
PR000207,PR000208


No comments:

Post a Comment