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  SQL Server Development (2000)  Lame Question 3

Author  Topic  Beefy Starting Member 21 Posts Posted - 2001-02-28 : 11:40:24 Hello, Say I have a table.... 1,aaa,500 2,aaa,100 3,bbb,200 4,aaa,50 5,ccc,100 6,bbb,400 How do I build a sp to get this. 1,aaa(500:100:50),3 2,bbb(200:400),2 3,ccc(100),1 The last column is the count... Please help, or it is a frontend job.. :o/ Many Thanks in advance.. Beefy ..... Women may well be able to fake orgasms, but men can fake whole relationships .....