[dba-SQLServer]Stored Procedure Mystery

Nicholson, Karen knicholson at gpsx.net
Tue Jan 13 13:08:17 CST 2004


Where has everybody been?  No messages in like, forever.  Did you all hit
the 
lottery?

Here is the top question of the day!!!!

I have three stored procedures that I need to run in order for each account.

exec ap_system_to_b32 279104, '6881.7841', 'GUARD', 'A', 0 
exec ap_system_to_b32 279104, '6881.7841', 'GUARD', 'C', 0 
exec ap_cs_account_to_change_tran 279104, 'GUARD',  '6881.7841' 

Now, I have a file that contains that 6 digit number following the b32, and
the corresponding
'6881.xxxx' number in another file.  All other values are constant.

Is there some way (in English) to have these procedures run once with
values, go to the next line and grab the next values and populate the line,
execute, go to the next set of values, etc.

THANKS!


More information about the dba-SQLServer mailing list