| Author | Message | ||
Side Hero Username: Twitter Post Number: 2393 Registered: 10-2009 Posted From: 67.84.98.23 Rating: N/A |
did you use sp_describe_cursor to see the rows in cursor? | ||
Platypus Junior Artist Username: Platypus Post Number: 303 Registered: 01-2008 Posted From: 122.175.68.75 Rating: N/A |
One of my cursors is processing only the first row all of a sudden. The SELECT query returns five rows but the cursor is executed only once. The @@FETCH_STATUS variable gets a -1 after processing the first row and hence is exiting out of the WHILE loop. Any ideas? The code was working fine until a few days ago. Recently there has been a DB configuration problem. Once it was resolved, this code stopped working. There are 10 types of people in this world. Those who understand binary and those who don't. |