Hi Koen, thanks for replying.

Not sure how to set up my variable (it's an integer in our database so what would the data type be as a variable?). ...

Hi Greg

With all the excellent advice that I got on this forum I think I overcomplicated things that I could have done with an Execute Task and T-SQL, as per...

Ok people, I think I know what I said was wrong. I am not going to update my stock with what I want to do. The table that...

Hi Greg

Thanks for your answer. All I'm looking for at this stage is to update a table using two dates, most preferably in a for/foreach loop. The other...

I will insert the code into the table. Don't worry about the query, as I know that it works, but here follows:

It will most probably start with:

INSERT...(blah blah blah

select...

Hi Koen

This is just an example that I have used of course. We want to replenish items (stock) at branches that are in other branches. Think of this...

I have rewritten my first post.

Kind regards

Hi Phil

Here is additional sample data. This is what I get when I run a query.

facilityItemCode ItemDescription ...

Hi Phil

I am not sure with the 'link in your signature' so I will respond this way:

The 100, 110, etc is the fluctuation of the stock, in other words the...

I'll ask him the day he fires me, lol.

Seriously, I'm still to new at the company to question his 'motives'. Will leave the questions for a later time:-D

Oh, my code needed to be in quotes.

Hi Koen

thanks for coming back. I have figured out this one thanks. NOLOCK, btw, is something standard that we use here. I have to use it because...

If I can really simplify it, it comes down to basic stock replenishment. If branch A is out of a certain item (stock), we want to know if the...

Hi John

Some of those fields gets updated daily so the updated data will also then be pulled into this table. It is essentially to look between branches and see...

No, it's not part of an index in this scenario