I am having a challenge with a Fetch statement being used in a stored procedure. I am declaring a cursor and fetching data into a set of variables. The variable types match the column declarations exactly. There is data in the table from which I am fetching. @@FETCH_STATUS is 0 before the fetch and -1 after. As anyone any ideas why?
The code I am using is:
DECLARE EQlist CURSOR FOR SELECT <a bunch of columns> FROM <my table> OPEN EQlist FETCH NEXT FROM EQlist INTO <properly configured variables.