I always wondered how to turn the results of a SQL query INTO a delimited string. On a whim I did a google search today and found out how. The technique actually isn't that complex.
Check out how by clicking [HERE].
Here is a primitive example of how it is done from the above page.
DECLARE @p_str VARCHAR(1000)
SET @p_str = ''
SELECT @p_str = @p_str + ',' + CAST(productid AS VARCHAR(6))
FROM [order details]
WHERE orderid = @p_order_id