[CapC]

I didn't end up laughing much when I found this nice little gem nestled into some update processing I was working on in an attempt to assist in figuring out why there was nothing being loaded into a specific staging table.

Essentially deleting all records from the t_table where 1=1.

DELETE FROM t_provid
WHERE EXISTS
  ( select prov_name p
     from ind
     where p.prov_name = prov_name
   );

This post has been edited by CapC: 31 May 2012 - 03:43 PM

[Valek]

Please tell me they weren't intentionally emptying the table and using that. TRUNCATE is much, much cleaner.