
March 31st, 2004, 01:13 PM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Stored Procedures - SQL
For some reason when I create the Stored Procedure, the script executes for more records than the cursor returns on its own. In other words, when I run the Select statement on its own, it returns one record, so I would expect the script to run for only one record, but for some reason it runs for numerous records. I don't understand how this could happen if the cursor is supposed to return only one value.
|