USP_ADJUSTMENTHISTORY_GIFTINKIND_SAVEHISTORY

Store historical sold gift-in-kind adjustment information for reporting purposes.

Parameters

Parameter	Parameter Type	Mode
@GIFTINKINDPAYMENTMETHODDETAILID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@GIFTINKINDSALEADJUSTMENTIDS	xml	IN

Definition

Copy



            create procedure dbo.USP_ADJUSTMENTHISTORY_GIFTINKIND_SAVEHISTORY
            (
                @GIFTINKINDPAYMENTMETHODDETAILID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime,
                @GIFTINKINDSALEADJUSTMENTIDS xml
            )
            as
                set nocount on
                /*Before calling this procedure, be sure that you call USP_SAVE_GIFTINKINDPAYMENTMETHODDETAILADJUSTMENT and then save changes to the GIFTINKINDPAYMENTMETHODDETAIL table*/

                declare GIFTINKINDSALECURSOR cursor local fast_forward for
                select
                    T.c.value('(GIFTINKINDSALEID)[1]','uniqueidentifier') as 'GIFTINKINDSALEID',
                    T.c.value('(GIFTINKINDSALEADJUSTMENTID)[1]','uniqueidentifier') as 'GIFTINKINDSALEADJUSTMENTID'
                from @GIFTINKINDSALEADJUSTMENTIDS.nodes('/GIFTINKINDSALEADJUSTMENTIDS/ITEM') T(c)

                declare @GIFTINKINDSALEID uniqueidentifier, @GIFTINKINDSALEADJUSTMENTID uniqueidentifier
                open GIFTINKINDSALECURSOR
                fetch next from GIFTINKINDSALECURSOR into @GIFTINKINDSALEID, @GIFTINKINDSALEADJUSTMENTID

                while (@@FETCH_STATUS = 0)
                begin
                    exec dbo.USP_ADJUSTMENTHISTORY_GIFTINKINDSALE_SAVEHISTORY @GIFTINKINDSALEID, @CHANGEAGENTID, @CHANGEDATE, @GIFTINKINDSALEADJUSTMENTID

                    fetch next from GIFTINKINDSALECURSOR into @GIFTINKINDSALEID, @GIFTINKINDSALEADJUSTMENTID
                end

                close GIFTINKINDSALECURSOR
                deallocate GIFTINKINDSALECURSOR