Home Forums SQL Server 2005 T-SQL (SS2K5) "Select Where In" using a parameter? RE: "Select Where In" using a parameter?

  • February 22, 2008 at 6:17 am

    #781059

    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