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_PaymentWHERE
registrationid = T .registrationid FOR XML PATH('')),len((SELECT (',' + paymentid)FROM
tbl_PaymentWHERE
registrationid = T .registrationid FOR XML PATH('')))-1)FROM
tbl_PaymentOUTPUT :
PR000182,PR000191
PR000183,PR000192
PR000194
PR000202
PR000203
PR000206
PR000207,PR000208
No comments:
Post a Comment