>If you're sure you're inserting into the same database as you're querying, then the WHERE clause has some characteristic that's not met by the new records. We can't guess from afar what it is- sorry! However, earlier advice re pulling records in Management Studio and compare found vs not found records, and reviewing profiler, may give you an "aha!" moment especially if you focus on what's in your WHERE.
>
>Re adding records: dbfs add records sequentially, so if you do an unordered query you can expect results in the order added. Whereas in SQL Server, an unordered query is literally in no particular order. You could order by your identity field if you need them in the order added.

Getting back PK/ID field from backend for new records might also be the problem...