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..

[Back to original message]