Posted by Rex on 02/12/07 05:08

Hi I have a table called "Member" as given below..

familyID memberID firstName
-------- -------- --------------------
0 7 Stuart
0 5 Kasey
0 1 Sally
0 2 Cooper
1 9 Rosemary
2 3 Lisa
2 6 Stephanie
3 4 mandy
3 8 Fisher


I want to create a view, storedProcedure or a Function (whatever is
possible in SQL Server 2000) that returns data that looks something
like this:


familyID member1 member2 member3 member4 (columns can go to..
memberN )
------- ---------- ---------- --------------

0 Stuart Kasey Sally Cooper
1 Rosemary
2 Lisa Stephanie
3 Mandy Fisher


Any help would be greatly appreciated..

• Next in forum: Migrating to 2005, need advice
• Prev in forum: Re: Where is my dts?
• Thread view: Problem with SQL server 2000

[Reply to this message]