I need to know how can I use PIVOT , my query
INNER JOIN il_cps_conversion.dbo.HEALTH_IMMUNIZATION_DEFINITION B
ON A.HIS_HIM_OID = B.HIM_OID
--AND STDNT.STD_OID = A.HIS_STD_OID
AND A.HIS_FIELDB_001 = '0'
AND A.HIS_STD_OID = 'std01000001256'
AND B.HIM_SERIES_ID <> 'TD'
returns following data set with six rows
and I need one row with all the six series_id . Like below:
std01000001256: DTP, MMR, MUM, RUB, TDP, VAR
Any suggestion will help.