Re: DELETE records when certain parameters are met

[Peter Brawley]

> Might be too much work to have it create a new table with results, then delete from there,

?! Too much work for you, or for the server?

A set-based solution like this will be less work for the server than a row-logic solution of the sort you were attempting. If you can find a way to get it done all with a subquery rather than a temp table, by all means post it.

> then move it back.

Eh? Move what back where?

< I just need it to really only look at 2 fields:

What it looks at depends on the structure of the table and the algorithm used.