-
What SQL do I need to say, pivot, a table? For example: I have a view that shows multiple rows of one record because it can be called differently:
ID Name
1 abdomen
1 abdominal
1 abdominal aorta
I would like to create a view that looks like:
ID Name 1 Name 2 Name 3
1 abdomen abdominal abdominal aorta
And how to you deal with the variable number of columns?
I am happy if I can just get:
ID Name string
1 abdomen,abdominal,abdominal aorta
Thanks in advance to your help!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|