you've to either do that or put the required values onto a temporary table and do like
DELETE t
FROM YourTable t
INNER JOIN TempTable tmp
ON tmp.field = t.name
WHERE .... any other conditions
where do you got these values from? is it already present in a master table field?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Easier way to delete specific records?
Posted - 05/01/2012 : 14:49:34
