spClone_DonorScrollers

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CloneContentID	int	IN
@ClonedContentID	int	IN

Definition

Copy



            create procedure dbo.spClone_DonorScrollers
            (
                @PKID                int output,
                @CloneContentID        int,
                @ClonedContentID    int
            )
            as
            begin
                begin transaction

                insert into dbo.DonorScrollers
                (
                    ContentID,
                    FundraiserIDs,
                    GiftTypes
                )
                select 
                    @CloneContentID,
                    FundraiserIDs,
                    GiftTypes
                from dbo.DonorScrollers
                where ContentID = @ClonedContentID

                select @PKID = @CloneContentID

                commit transaction
            end