Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
henrikop
Constraint Violating Yak Guru
280 Posts |
 Posted - 2001-04-13 : 05:37:42
|
| I work with SQl Server 7.0 and ASP.My problem is that I'd like to use Stored Procedures so I can schedule jobs to run each night. The problem I run into is like this:For each record in a table I like to run a stored procedure to create a record(s) in another table. But how do I run a stored procedure for each record?In VB I use code like this:Do until RecordSet.EOFIf RecordSet!ID > 0 then Call function that makes a new record (Recordset!Name, Recordset!Number, etc.)end if.move nextLoopThanx in Advance,Henri |
|
|
|
|
|
Run a Stored Procedure for each record