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
( select prov_name p
where p.prov_name = prov_name
This post has been edited by CapC: 31 May 2012 - 03:43 PM