Though that is very resource intense(I hate to write a million records to temporary table, though I am gonna truncate it), I would go in that direction, as accuracy is...

DTS does the things only in serial manner, I mean one after the other. Check, whether you are executing two jobs at the same time. Ideally, put those on success/on...

Thanks for all your replies.

With Steve and Remi's solutions, I see a problem, we are concatenating two query results; I guess it works as long as the number of records...