I'm new to databases, I wanted to known if there is away to create a store proc. that will look at a list table and compare the Order_IDs on this table with new query like this 'give me all order_ids that are not in this table' then fill another table with the results then update the list table. This way I can never pull the same order_ids.
Any help would be great. I do this mannualy with excel.
Any help would be great. I do this mannualy with excel.