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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Is this possible?

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 SplitCostID
10034 3333
10045 3333
10946 3435
10957 8563
10982 8563
10945 3333

What I want to is somehow group the jobId's that are related by SplitCostID but display them as a string like:

SplitCostID JobID
3333 10034|10045|10945
8563 10957|10982
etc.

Is this possible?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-28 : 07:02:36
use CSV ? http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -