I have a cursor set up within an insert trigger on a table that selects all of the records from "inserted". However after I perform my fetch, the FETCH_STATUS is returning a value of -1. I perform the following immediately before opening and fetching from the cursor just to check to make sure the proper values are in the inserted table:
select * from inserted
and when I insert a record into the target table, the values returned from the above query are correct. However after the cursor is opened and the fetch is performed from inserted, I get a fetch_status of -1. Why would this be happening?
Thanks,
Greg
select * from inserted
and when I insert a record into the target table, the values returned from the above query are correct. However after the cursor is opened and the fetch is performed from inserted, I get a fetch_status of -1. Why would this be happening?
Thanks,
Greg
