problems getting value in crosstab fashion in Sql server 2000

R

Rex

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

Guest

Your request I believe is impossible based on the fields you have provided.
Since your question is entirely related to SQL Server syntax, you might have
better luck asking a SQL Server news group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query problem.. 1
SQL SELECT to order Text in a numerical fashion 3
Concatenating fields 0
Getting the autonumber value after adding new record when dao points to SQL rather than JET 3
Function Between in SQL Server 2000 18
Inserting dates into SQL Server DB 11
Help me in Specifying Connection string to SQL server 2000 running on remote machine 1

Top