SET @productIds ='
SELECT
ParamValues.ID.value('.','VARCHAR(20)')
FROM @productIds.nodes('/Products/id') as ParamValues(ID)
Sunday, March 01, 2009
Passing Lists in SQL Server 2005
DECLARE @productIds xml
SET @productIds ='3 6 15
SELECT
ParamValues.ID.value('.','VARCHAR(20)')
FROM @productIds.nodes('/Products/id') as ParamValues(ID)
SET @productIds ='
SELECT
ParamValues.ID.value('.','VARCHAR(20)')
FROM @productIds.nodes('/Products/id') as ParamValues(ID)
Subscribe to:
Posts (Atom)
