> instead I resorted to execute block, like this (in general terms, not
> adapted to your specific case):

And, yet another option.
I don't know if it's good or bad, but I do this frequently and have no
problems with performance or results.

If this is not a run-once command, but most likely is feature needed
frequently, consider a stored proc.

You can create a For... Select...into... Begin...End cursor and then
delete all results for that cursor in the "Begin... End" part.