<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Updating In-Memory (Temporary) SQL Tables With UPDATE / DELETE Clauses Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:739.view Date Posted: May 30, 2007 at 2:38 PM ---- --------------------------------------------------------------------------------------- ---> DECLARE @id TABLE ( id1 INT, id2 INT ) ; INSERT INTO @id ( id1, id2 )( SELECT TOP 5 p.id AS id1, p.id AS id2 FROM pivot100 p ); UPDATE @id SET id2 = (id2 + 5) ; DELETE FROM @id WHERE id1 >= 4 ; SELECT * FROM @id