SELECT Flag,
STUFF((SELECT ',' + CAST([ITEMID] AS varchar(5)) + '-' + [SUBITEM]
FROM TABLEA
WHERE Flag = t.Flag
ORDER BY [ITEMID]
FOR XML PATH('')),1,1,'') AS [ITEM-SUBITEM]
FROM (SELECT DISTINCT Flag FROM TABLEA WHERE Flag <> '-')t
once you happy with above code use it in insert as
INSERT INTO [TABLE MAPPED]
the above select query
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Table Mapping
Posted - 01/23/2013 : 03:18:46
