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)
 storing multiple values in a variable ...

Author  Topic 

PeterG
Posting Yak Master

156 Posts

Posted - 2004-08-19 : 11:58:55
from a select statement. I know arrays are not supported in SQL 7.

Here's what I'm trying to do:

I want to find out what groups a user belongs to by using a select statement and then loop through each group to do group processing. Can I store these values somehow and then be able to reference each group?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-08-19 : 12:03:03
#temp table is one option.
comma separeted string is another.

i prefer #temp table.


Go with the flow & have fun! Else fight the flow :)
Go to Top of Page
   

- Advertisement -