sql help

[rikki]

i have a list of sql statements in my middle tier like this 

exec proc 'a','b'

exec proc 'a2','b2'

exec proc 'a3','b3'

exec proc 'a4','b4'

how do I send all these sql statements to a proc and execute them or by any other way?

[mtkr]

aa tble lo identity undaa??

if yes... use some while loop...

or use something lky cursors...

or use ssis - use for each loop ado enumerator and use table in that... frst select records frm table n nxt use execute sql task to pass values to tht stored proc...

[rikki]

15 minutes ago, mtkr said:

aa tble lo identity undaa??

if yes... use some while loop...

or use something lky cursors...

or use ssis - use for each loop ado enumerator and use table in that... frst select records frm table n nxt use execute sql task to pass values to tht stored proc...

no while loop it is just a text but it is in the form of "Exec proc 'valu1', 'valu2'; Exec proc 'valu3', 'valu4';" 

[mtkr]

aa 4 stored procs,  same  aa!! r diff procs aa??

n aa aa A n B values cmng frm same tbl r diff values cmng frm some wht else?

[rikki]

forget about tables here 

there is a proc name 'HelloProc' which has 2 parameters 

I have a string like this 'Exec HelloProc para1, para2; Exec HelloProc para3, para4; Exec HelloProc para5, para6;.."

yes it is same proc 

para1, para2, etc are just some values