ThomasRushton (7/5/2016)

---

Without looking in great detail, I suspect it might be something to do with this bit:

CASE WHEN ( @counted = 1 ) THEN @Stock

You've declare

excellent , thanks , appreciating your help .

also if total demand less than or equal available it will result the issue,

my issue if total demand more than available but if less or equal i already add...

you can change in the value of QtyDemand and it will result the issue

declare @Transaction table

(

ID...

twin.devil (6/27/2016)

---

declare @Transaction table

(

ID int

, Store char(3)

, SKU int

, AvailableQty int

, ReceivingStore char(3)

, QtyDemand int

)

insert into @Transaction

select 1, 'ST1', 100, 20, 'ST2', 14union all

select 2,...

yes exactly