Would it be easier to copy the data you want to keep out to another location?  If those 5 locations are small relative to the overall data set, inserting the good...

Same Idea as Jonathan's query, I just prefer this for readability (which is subjective :))


Select possibleValue from mydb.dbo.PossibleValuesTable
EXCEPT
select actualValue from mydb.dbo.ActualValuesTable


I am sorry - but I don't recall  Jacob's XMl table function.  That said - the direct SQLXML query to get that back looks something like :