You can use string manipulation, but it may be easier and simpler to use XML features that SQL Server offers. To select the data that you described run this query:SELECT
a.sku,
b.Bullets
FROM
(SELECT DISTINCT sku FROM Product) a
OUTER APPLY
(
SELECT bullet_point AS [li]
FROM Product b
WHERE b.sku = a.sku
FOR XML PATH('ul')
) b(Bullets)
If that looks like what you want, then you can use that as a subquery to do the update, as shown below:UPDATE p SET
Bullets = s.Bullets
FROM
(
SELECT
a.sku,
b.Bullets
FROM
(SELECT DISTINCT sku FROM Product) a
OUTER APPLY
(
SELECT bullet_point AS [li]
FROM Product b
WHERE b.sku = a.sku
FOR XML PATH('ul')
) b(Bullets)
) s
INNER JOIN Product p ON p.sku = s.sku;
Need to combine rows
Posted - 10/14/2012 : 15:42:26
