Send it as XML? Is this sql server 2000 or 2005? Either way, xml will work nicely, but sql server 2005 makes this a lot easier.
Thanks, Nick Cipollina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 9:15 AM To: [EMAIL PROTECTED] Subject: [NF] Passing list of values to SQL Server? Perhaps I'm approaching this from the wrong angle. Here's my need: I need to send any number of single field values to SQL Server so that several queries can act upon those values. I was originally thinking a temp table but if there's a way I could pass a list of values to a stored procedure, that'd suffice. Generally, I have queries that use the list of values passed like so: select * from MySQLTable a1 inner join SomeOtherRelatedTables b1 on a1.key = b1.key where a1.cKeyField in (list of values passed from client app) Is there a way to pass this list of values and have it easily usable inside an SQL statement as opposed to using temp tables like I tried initially? The problem, to repeat, is that multiple users might kick off the process with different criteria, so they can't use the same temp tables at the same time. Any help appreciated...thanks! --Michael [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
