ID OID QID ANs 1 1 1 a 2 1 2 b 3 1 2 c
ID OID QID ANs 1 1 1 a 2 1 2 b,c
SELECT A.OID,A.QID,STUFF(( SELECT ',' + B.ANS AS [TEXT()] FROM TABLENAME B WHERE A.QID= B.QID AND A.OID= B.OID FOR XML PATH('') ), 1, 1, '' ) FROM TABLENAME A GROUP BY A.ORDERID,A.QUESID ORDER BY ORDERID ASC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)