spClone_GivingHistory2
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @CloneContentID | int | IN | |
| @ClonedContentID | int | IN | |
| @CurrentUsersID | int | IN | |
| @NewGuid | uniqueidentifier | IN |
Definition
Copy
CREATE procedure [dbo].[spClone_GivingHistory2]
(
@PKID int output,
@CloneContentID int,
@ClonedContentID int,
@CurrentUsersID int,
@NewGuid uniqueidentifier
)
as
insert into [dbo].[GivingHistory2]
(
[SiteContentID],
[GiftTypes],
[Campaigns],
[Funds],
[Appeals],
[GiftQueryID],
[IncludeSoftCredit],
[ResultsPerPage],
[UseCustomFilter],
[UseCustomColumn],
[IncludePending],
[IncludeSummary],
[IncludeGiftTotal],
[IncludeGiftAidTotal],
[IncludePendingTotal],
[IncludePledgeTotal],
[IncludeBalanceTotal],
[IncludeTotalsCurrency],
[PledgePaymentPageID],
[RecGiftEditAllowAmtUpdate],
[RecGiftEditAllowFreqUpdates],
[RecGiftEditAllowPmntTypeUpdate],
[RecGiftEditMinUpdateAmt],
[RecGiftEditFilterFunds],
[RecGiftEditFilterAppeals],
[RecGiftEditFilterQueryID],
[RecGiftEditFilterUseCustomFilter],
[RecGiftEditFreqUseGeneralRecurrence],
[RecGiftEditFreqAllowStartDateUpdates],
[RecGiftEditFreqAllowEndDateUpdates],
[RecGiftEditFreqSpecifics],
[RecGiftAdditionalDonationPageID],
[IncludeSoftCreditsTotal],
[IncludeHardCreditsTotal],
[RecurringGiftPaymentPageID],
[UnpaidEventsPaymentPageID]
)
SELECT
@CloneContentID,
[GiftTypes],
[Campaigns],
[Funds],
[Appeals],
[GiftQueryID],
[IncludeSoftCredit],
[ResultsPerPage],
[UseCustomFilter],
[UseCustomColumn],
[IncludePending],
[IncludeSummary],
[IncludeGiftTotal],
[IncludeGiftAidTotal],
[IncludePendingTotal],
[IncludePledgeTotal],
[IncludeBalanceTotal],
[IncludeTotalsCurrency],
[PledgePaymentPageID],
[RecGiftEditAllowAmtUpdate],
[RecGiftEditAllowFreqUpdates],
[RecGiftEditAllowPmntTypeUpdate],
[RecGiftEditMinUpdateAmt],
[RecGiftEditFilterFunds],
[RecGiftEditFilterAppeals],
[RecGiftEditFilterQueryID],
[RecGiftEditFilterUseCustomFilter],
[RecGiftEditFreqUseGeneralRecurrence],
[RecGiftEditFreqAllowStartDateUpdates],
[RecGiftEditFreqAllowEndDateUpdates],
[RecGiftEditFreqSpecifics],
[RecGiftAdditionalDonationPageID],
[IncludeSoftCreditsTotal],
[IncludeHardCreditsTotal],
[RecurringGiftPaymentPageID],
[UnpaidEventsPaymentPageID]
FROM [GivingHistory2]
WHERE SiteContentID = @ClonedContentID
INSERT INTO [dbo].[GivingHistoryUsedFields]
(
[SiteContentID],
[FieldID],
[DisplayOrder]
)
SELECT @CloneContentID, [FieldID], [DisplayOrder]
FROM [dbo].[GivingHistoryUsedFields]
WHERE SiteContentID = @ClonedContentID
SELECT @PKID = SCOPE_IDENTITY()
exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1