Joining Table output into one field

[Dimm]

I have an sp that gets product information from a table. I need to join all the results into one string

Example

Name Value Units
Width 35.0 cm
Depth 50.1 cm
Weight 0.75 kg
Height 0.7 cm

Into

Width 35.0 cm | depth 50.1 cm | Weight 0.75 KG | Height 0.7 cm

I guess there is an easy way, but it has me stumped

TIA

 

[JohnDTampaBay]

Does the procedure produce results for a single product or multiple products? For multiple products, you may have to wrap this code in a cursor.

-- Assumes a single product's data is returned
-- and the sample rows have been selected
-- into the temp table #Measures...

DECLARE @MeasureString varchar(1000)

SELECT @MeasuresString =
       IsNull(@MeasuresString + ' | ', '')
     + Name + ' '
     + Value -- May need to CAST AS varchar
     + Units
FROM #Measures

SELECT @MeasuresString

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[Dimm]

Nice one thanks

I learn a litle every day - problem is I forget a lot more!