Posting Yak Master
Posted - 05/15/2012 : 11:08:08
| Hi, I have a very complicated issue and I don't know where to go.
Basically, I need a way to concatanate lines 1-3 into one string and keep all the commas. The desired output is below. In my database, I have over 3.5 million records that look like this and some have ten of the same box with a different for each box. It would need to show one unique box by somehow concatanting all the columns below it. My co worker suggested some kind of loop, but I have no idea where to even begin. Also, the loop would have to run like 3.5 million times so I'm not sure how this would affect performance. Any help would be greatly appreciated.
B3399 ,123, , ,
B3399 ,345 , ,
B3399 ,123, 41, ,
B3399 ,123, , , ,345 , , ,123, 41, ,
Edited by - joe8079 on 05/15/2012 11:11:24