Page History

-- =============================================
-- Author:      Asamco BV, Alexander Toufexis
-- Create date: 30/4/2020
-- Description: updates markup (uses _as_UpdateMarkup), but allows for WH "all".
-- =============================================
create or ALTER   PROCEDURE [dbo].[_as_UpdateMarkup_allowAll]
    @StockCode varchar(100)
    ,@WHCode varchar(100)
    ,@MarkupPerc float
    ,@PriceListID int = 154
AS
BEGIN

DECLARE @WHCode2 varchar(100)

IF @WHCode <> 'all'
	BEGIN
		exec [_as_UpdateMarkup] @StockCode, @WHCode, @MarkupPerc, @PriceListID;
	END
ELSE --@WHCode
	BEGIN
		DECLARE MyCursor CURSOR 
	FORWARD_ONLY
	FOR
	SELECT W.Code FROM WhseStk WS
		LEFT JOIN WhseMst W ON WS.WHWhseID = W.WhseLink
		LEFT JOIN StkItem S ON WS.WHStockLink = S.StockLink
		WHERE S.Code = @StockCode

	OPEN MyCursor

	FETCH NEXT FROM MyCursor INTO @WHCode2
				
	WHILE @@FETCH_STATUS = 0 
		BEGIN	
			exec [_as_UpdateMarkup] @StockCode, @WHCode2, @MarkupPerc, @PriceListID;
		FETCH NEXT FROM MyCursor INTO @WHCode2
		END 
	CLOSE MyCursor
	DEALLOCATE MyCursor
	END	--ELSE @WHCOde <> all..


END