declare @cursor1_status --hold the first fetch status declare @cursor1_holder declare @cursor2_status --hold the second fetch status declare @cursor2_holder --declare cursors declare first_cursor cursor for.... declare second_cursor cursor for.... --open cursors open first_cursor open second_cursor --fetch cursors and use another variable to hold the fetch -- status fetch next from first_cursor ..