Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
p.shaw3@ukonline.co.uk
Posting Yak Master
103 Posts |
Posted - 2007-07-28 : 06:58:10
|
I have data in a table similar to this:JobId SplitCostID10034 333310045 333310946 343510957 856310982 856310945 3333What I want to is somehow group the jobId's that are related by SplitCostID but display them as a string like:SplitCostID JobID3333 10034|10045|109458563 10957|10982etc.Is this possible? |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|