Salam semua... saya nak minta sifu2 tolong saya.
saya ada masalah nak papar data bila guna SQL seperti di bawah:
[html]
DECLARE @Sample TABLE (ID INT, SubID INT)
INSERT @Sample
SELECT 1234, 112 UNION ALL
SELECT 1234, 113 UNION ALL
SELECT 1234, 114 UNION ALL
SELECT 3234, 212 UNION ALL
SELECT 3234, 213 UNION ALL
SELECT 3234, 214
-------------------------------------------------------------
SELECT i.ID, STUFF(g.y, 1, 1, '') AS SubIDs FROM ( SELECT ID FROM @Sample GROUP BY ID ) AS i
CROSS APPLY ( SELECT DISTINCT ',' + CAST(SubID AS VARCHAR(11))
FROM @Sample AS s
WHERE s.ID = i.ID ORDER BY ',' + CAST(SubID AS VARCHAR(11)) FOR XML PATH('') ) AS g(y)
[/html]
Kalau Run kat SQL server data kuar cantik.. contoh data:

[html]
ALI 2012 January,February,March
ABU 2012 January,February
[/html]
tapi bila saya exec dalam page asp DataSet cam kosong.. Harap ada yang sudi reply.. thanks..

Edited January 10, 201214 yr by Dade Murphy

moved!