Subject Re: SQL NOT IN
Author Adam
--- In, "Dion" <27824912424@v...> wrote:
> I tried your suggestion, Alexandre, and the records I am looking for are
> returned, although the EXISTS script(like the IN) also returns an empty
> result set.
> Thanks.


I think the script looks fine. Are you sure this isn't just an
isolation level problem where your select statement cant see the
inserted records because they were not committed until after the
transaction started?

Otherwise, create a sql script to duplicate what you are experiencing.
If you can't duplicate the problem, then you need to fix up your
transaction management there. If you do duplicate it, post the script
and we can check if there are any runs.

The script should create the tables, insert the data then run the select.