Is it possible to execute a sp in a loop?

[aco636]

Hi there

I am pretty used to writing vbScript to manage databases.
However SQL Stored Procs are pretty new to me. Any help gratefully received.

I would like to create a record set from a normal SELECT Statment (Will return about 3,500 records) and execute a script for each record.

EG:
SELECT SerialNo FROM ......

DO WHILE NOT RECORDSET.EOF (END OF FILE/LIST)
BEGIN TRAN
UPDATE & INSERT various
COMMIT
LOOP

 

[GShen]

Yes, you need to use a CURSOR. It allows you to 1st select the record you want to process as a driver and with a WHILE
Loop allows you to do whatever you want, eg. insert, update, delete, etc.

Remember when... everything worked and there was a reason for it?