USP_ADJUSTMENTHISTORY_STOCK_SAVEHISTORY

Store historical sold stock adjustment information for reporting purposes.

Parameters

Parameter	Parameter Type	Mode
@STOCKDETAILID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@STOCKSALEADJUSTMENTIDS	xml	IN

Definition

Copy



            CREATE procedure dbo.USP_ADJUSTMENTHISTORY_STOCK_SAVEHISTORY
            (
                @STOCKDETAILID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime,
                @STOCKSALEADJUSTMENTIDS xml
            )
            as
                set nocount on
                /*Before calling this procedure, be sure that you call USP_SAVE_STOCKDETAILADJUSTMENT and then save changes to the STOCKDETAIL table*/

                declare STOCKSALECURSOR cursor local fast_forward for
                select
                    T.c.value('(STOCKSALEID)[1]','uniqueidentifier') as 'STOCKSALEID',
                    T.c.value('(STOCKSALEADJUSTMENTID)[1]','uniqueidentifier') as 'STOCKSALEADJUSTMENTID'
                from @STOCKSALEADJUSTMENTIDS.nodes('/STOCKSALEADJUSTMENTIDS/ITEM') T(c)

                declare @STOCKSALEID uniqueidentifier, @STOCKSALEADJUSTMENTID uniqueidentifier
                open STOCKSALECURSOR
                fetch next from STOCKSALECURSOR into @STOCKSALEID, @STOCKSALEADJUSTMENTID

                while (@@FETCH_STATUS = 0)
                begin
                    exec dbo.USP_ADJUSTMENTHISTORY_STOCKSALE_SAVEHISTORY @STOCKSALEID, @CHANGEAGENTID, @CHANGEDATE, @STOCKSALEADJUSTMENTID

                    fetch next from STOCKSALECURSOR into @STOCKSALEID, @STOCKSALEADJUSTMENTID
                end

                close STOCKSALECURSOR
                deallocate STOCKSALECURSOR