I try to avoid using cursors when I can, mainly because I lack any reasonable experience using them.

I see what you're saying and it makes sense. I think what I'm...

Is this a legal condition?

WHEN  CUSTOMERNUMBER = CAST(SUBSTRING(Account_Number, 2, 8) AS int)

The problem is I need it to do it on a record by record basis. IF statements do a table-wide check against whatever my criteria is, correct?

EDIT: I've sorted out a...

All apologies, I just try to keep like questions in the same place instead of opening up a new topic.

When I say new to databasing, I mean heavy emphasis on the new. At the time, executing the DTS package seemed more straightforward to and also easier to understand. In...

I'm having difficulties trying to run the DTS package from a procedure. I've tried both methods listed above, but to varying results.

The first returns an error, stating that the...