Used Cursors For the First Time This Week

I've been using sql for about 6 1/2 years now. Mainly for report writing and research/validation.

I am not allowed to write sql scripts that edit my applications tables, so my experience with a lot of that side is limited to a few custom views/tables/SPs/jobs.

Anyways. I'm importing a bunch of items (mainly jobs) into our test environment to bring it closer to production, and to avoid having jobs shoot out bad data to executives, I would've needed to update about 30 db mail SPs @recipients lists after each db refresh, which I do once a week or so.

Not the biggest deal, but I figured I'd just make a script to check SPs for an @recipient list and update if one exists.

Just refreshed the dB and ran it officially for the first time. Feels good, yo.