November 8, 2011 at 6:16 am
Hi
Need help with concatenation and pivoting:
@table 1 is as follows
ID More_id description
----------------------------------
11 null text
22 null text1
33 6 text2
44 6 text3
55 null text4
66 null text5
-------columns from @table2 are as follows:------------------------------------
Product_specs - Values - ID - More_ID - description
-----------------------------------------------------
ProdID - 1111 - 11 - null - text
Name - cake - 22 - null - text1
color - brown - 33 - 6 - text3 +text2
size - 10 - 55 - null - text4
shape - square - 66 - null - text5
---#### -----I am looking for a format like below--------####
productID - Name - color - size - Shape - description
-------------------------------------------------------
1111 - cake - brown - 10 - square - Text +Text 1 +text2 +text3 +text4 + text5
I was able to pivot it until the shape column, now I am having difficulty putting the description column together.
any ideas? thanks
November 8, 2011 at 6:34 am
This should help:
http://spaghettidba.com/2011/10/13/concatenating-multiple-columns-across-rows/
-- Gianluca Sartori
November 8, 2011 at 11:20 am
Thanks I am trying to work it out
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply