Billy Pang
tuxedo_man at hotmail.com
Tue Jan 13 13:37:57 CST 2004
Where are the values grabbed from? A table or from the results of the sproc? Also, what is the signficance of the "exec ap_cs_account_to_change_tran 279104, 'GUARD', '6881.7841'" line? >From: "Nicholson, Karen" <knicholson at gpsx.net> >Reply-To: dba-sqlserver at databaseadvisors.com >To: "Dba-Sqlserver (E-mail)" <dba-sqlserver at databaseadvisors.com> >Subject: [dba-SQLServer]Stored Procedure Mystery >Date: Tue, 13 Jan 2004 14:08:17 -0500 > >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! >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca