Stored Proc Help Needed

Cursors are actually a nice feature of SQL, once you learn how to use them. This is probally the easiest way to use them, and it has worked every time for me. Assume that @col1 and @col2 are pre-defined variables. You also have to make sure that however many objects your select statement returns is how many objects you catch in the fetch next statement, even if you dont use them.

Begin Tran
Declare cur Cursor For Select column1, column2 From table
Open cur
Fetch Next From cur Into @col1, @col2
While @@Fetch_Status = 0
    Begin
    ...
    If @@ERROR <> 0
        Goto FAIL
    Fetch Next From cur Into @col1, @col2
    End
Close cur
Deallocate cur
Commit Tran
Goto DONE

FAIL:
Rollback Tran
Select -1 As RetVal,'SQL Error' As RetString

DONE:
--done

Yeah, I ussually try to avoid using cursors, but there are some cases where you just can't avoid using them, exspecailly when you more or less write SQL code all day just about for your job. I've always viewed cursors as "evil" and am ussually able to find a way to not use them, but there are those times...

That course sounds like fun, wish I had time to do something like that.