Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Return many joined records in just one record?

Author  Topic 

polira
Starting Member

1 Post

Posted - 2002-03-13 : 09:50:30
is there a way to return an inner join query with one->many results as one comma-seperated record?

ie.
Usually when you do an inner join on one->many result set you get something like

someuser; privelage1
someuser; privalage8
someuser; privelage12

is there a way (through sql or stored procs) to return a record like...

someuser; privelage1,privelage8,privelage12

Thanks!

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-03-13 : 13:19:29
search for CSV (Comma Separated Variables) on this site....this has come up many times.

Go to Top of Page
   

- Advertisement -