Repeatedly execute a stored procedure
- by manivineet
I have a situation where I need to repeatedly execute a stored procedure
Now this procedure (spMAIN) has a cursor inside which looks for a value from a table as T1,which has the following structure
ID Status
---- --------
1 New
2 New
3 success
4 Error
now the cursor looks for all rows with a status of 'New'
Now while…