DataTable/Set/Column as parameter for Stored Proc??

[bizzydint]

Ive got a query pulling out a list of ID numbers (along with other stuff) and the data is getting read into a DataTable then displayed.

Now I need to call another query passing the ID numbers as a parameter. Is there an easy way to do that?

Alternatively, the 2nd query is a "Select BLAH from TABLE WHERE ID IN (id numbers from previous query)"

So how would I convert the data from that specific column into a string of IDs??


Hope it makes sense....
van.

 

[wyrd]

Yes, use arrays. However, Sql Server doesnt directly support arrays, so youll need to use a temporary table as your array.