|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 9th, 2007, 01:12 AM
posted to microsoft.public.access.queries
|
|||
|
|||
problems getting value in crosstab fashion in Sql server 2000
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.. 
|
|
#2
February 9th, 2007, 03:36 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
problems getting value in crosstab fashion in Sql server 2000
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. -- Duane Hookom Microsoft Access MVP "Rex" wrote: 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..
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
