Untitled

Need to create comma separated list for each instance of value in SQL Server 2005?
IDcolumn1value1 | IDColumn2value1, IDColumn2Value2, IDColumn2Value3; IDcolumn1value2 | IDcolumn2Value2, IDcolumn2Value4

DECLARE @listStr VARCHAR(MAX)
SELECT  @listStr = COALESCE(@listStr+',' , '') + Component_Softpaq.SoftpaqNumber
FROM         Softpaq_SKU INNER JOIN
    ComponentVersion ON Softpaq_SKU.ComponentVersionID = ComponentVersion.ComponentVersionID INNER JOIN
    ComponentPass ON ComponentVersion.ComponentVersionID = ComponentPass.ComponentVersionID INNER JOIN
    Component_Softpaq ON ComponentPass.ComponentPassID = Component_Softpaq.ComponentPassID
group by Softpaq_SKU.SKUID, Component_Softpaq.SoftpaqNumber

SELECT @listStr