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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-06 : 10:14:01
|
| Daniel writes "I have a stored procedure that scrolls through a cursor and inserts data into a table on each pass through the cursor.When I run the stored procedure in Query Analyzer, it inserts 267 records into the table (as it should). However, when I run the same stored procedure with identical parameters from a web page (using the same user), it only loads the first 8 records into the table. No errors are generated. It doesn't matter how I change the parameters; it's always only the first 8 records that get entered.Do you have any idea what's going on? I'm completely stumped." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-06 : 10:16:01
|
| A. Why use a cursor for a simple INSERT? Just use INSERT INTO thisTable SELECT * FROM thatTable.B. You'll have to post your code in order for us to help.C. You also should explain what you are trying to do, there may be another way to do it...as mentioned above. |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-06-06 : 10:41:02
|
| Heh, Just use the word cursor and it's only a matter of minutes before people here jump all over ya ;)But with good cause... lets see the syntax for the statement, cursors can loop sometimes... It's possible your hitting a timeout from the webpageEdited by - M.E. on 06/06/2002 10:42:44 |
|
|
|
|
|
|
Stored procedure returns incomplete records