>There are ~1 million de-normalized 'adjustment rows' that I am checking about 20 different conditions on, but each of these conditions has multiple possibile entries.
Is this a one timer? Periodic?
How about creating clean staging tables from the messy data?
Perform the final update from the staging tables?
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!