Best way to write an update procedure in Sql Server
Posted on 2012-08-22
I'm an Oracle developer learning Sql Server / SSIS.
Typically, I write update procedures in Oracle, read the d.b. with a cursor, loop through the cursor, then write an update statement. Then send an e-mail with totals, etc.
I'm also in a Sql Server shop that does a lot of SSIS work. I'm familiar with the tool but haven't actually written anything yet.
In my first discussion with an SSIS developer, his first reaction was SSIS might not be the right tool for something like this.
What's the best approach for this (cursor, loop through data, update, e-mail with totals) ?