Sergiy

Thanks for helping. I will update the data in a temp table once a week and then, once I have the data by item number I will update the 30,000...

Thanks both for your help. I have this actual T-SQL but it times out (Timeout expired). (I have to calculate the inventory value but have tried on a test table...