spClone_GivingHistory

Parameters

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

Definition

Copy



    CREATE Procedure dbo.spClone_GivingHistory
    (
    @PKID int output,
    @CloneContentID int,
    @ClonedContentID int,
    @CurrentUsersID int
    )
    as

    DECLARE @NewGuid uniqueidentifier
    SET @NewGuid = NEWID()

    Insert into GivingHistory
    (GivingHistoryName,
    Guid,
    SiteContentID,
    GiftTypes,
    Campaigns,
    Funds,
    Appeals,
    Message,
    ExcludeSC,
    SCtext
    )
    Select     GivingHistoryName,
        @NewGuid,
        @CloneContentID,
        GiftTypes,
        Campaigns,
        Funds,
        Appeals,
        Message,
        ExcludeSC,
        SCtext
    From GivingHistory
    Where SiteContentiD = @ClonedContentID

    SELECT @PKID = @@Identity

    exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1