Adam Haines (2/19/2008)
DECLARE @IDString VARCHAR(MAX)
SET @IDString =
(SELECT (ID) + ','
FROM MYTABLE
--WHERE FILTER CAN GO HERE
FOR XML PATH(''))
This leaves a trail comma. I usually do something likeDECLARE @IDString VARCHAR(MAX)
SET @IDString =
(SELECT
CASE row_number() OVER(ORDER BY ID)
WHEN 1 THEN ''
ELSE ','
END + (ID)
FROM MYTABLE
--WHERE FILTER CAN GO HERE
FOR XML PATH(''))
Derek