Can you explain a little more what you are actually trying to accomplish?
It seems like you’re trying to do something that might be more appropriate in a procedural scripting language like VBScript, rather than SQL (which is set based.) Or perhaps use VBScript as a wrapper to do the iterations and call your SQL commands from it. - Andy O. ________________________________________ From: Joseph L. Casale [mailto:[EMAIL PROTECTED] Sent: Friday, February 29, 2008 12:09 PM To: NT System Admin Issues Subject: RE: SQL Scripting Help Thanks for the pointer Michael. If I have a comma separated list of values (I can change that format if it makes this easier), how do I iterate through each element pushing it into a variable? Thanks guys, jlc From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Friday, February 29, 2008 5:28 AM To: NT System Admin Issues Subject: RE: SQL Scripting Help Stored procedure. ☺ Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: Joseph L. Casale [mailto:[EMAIL PROTECTED] Sent: Friday, February 29, 2008 1:49 AM To: NT System Admin Issues Subject: SQL Scripting Help I have a series of commands I would like to loop through with a list of db names. Obviously it’s much easier to keep a list up to date and organized, then whole bunch of repetitive sets of commands. I can’t seem to be able to Google what I am looking for. Anyone got an idea to push me along? Thanks, jlc ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
