I have been provided a list of approx 1000 values. I need to perform an update based on these ID's. I performed a selection on this list. As an example
Select * from myTable where id IN (1, 2, 3, 4, 5, .... )
The results returned 995 out of the 1000 id's that were provided. Is there a way to write a script to determine which of the 5 id's that were provided are not in the list?