Re: While loop with Dynamic SQL

[Peter Brawley]

> How would you do this as opposed to doing it one at a time and how would you write this without the proc?

Sprocs are a bitch to write, debug & maintain, and in MySQL usually offer zero performance advantage. So in MySQL, the SQL Server rule of encapsulate if possible does not apply.

SQL is set-based. If a job entails row-to-row logic or recursion, you probably need to write an sproc. Such row-to-row processing is s-l-o-w. Your task appears to target a set of rows. So the initial assumption should be: it can be done with one or two SQL commands.

Rather than me do it for you, see if you can write a Select statement that defines the job rowset. Once you have that debugged, it should be pretty easy to derive the required Insert statement.