spClone_ECardPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@DestID	int	IN
@SourceID	int	IN
Definition

Copy


        CREATE    Procedure [dbo].[spClone_ECardPart]
                (
                @PKID int output,
                @DestID int,
                @SourceID int
                )
                as
                        insert into [dbo].[ECardPart]
                        (
                            SiteContentID,
                            MaxHeight,
                            MaxWidth,
                            MaxRecipients,
                            EmailTemplateID,
                            BrowseCategories,
                            ClientDonationsID,
                            UseRichTextMessage,
                            DisplayAllAsSingleFields
                        )                        
                        Select
                             @DestID,
                             MaxHeight,
                             MaxWidth,
                             MaxRecipients,
                             EmailTemplateID,
                             BrowseCategories,
                             ClientDonationsID,
                             UseRichTextMessage,
                             DisplayAllAsSingleFields
                        from [dbo].[ECardPart]
                        Where SiteContentiD = @SourceID;

                        SELECT @PKID = @@Identity;

                        insert into [dbo].[ECardPartTemplate]
                        (
                            ECardPartID,
                            ECardTemplateID,
                            SiteFoldersID
                        )                        
                        Select
                             @PKID,
                             ecpt.ECardTemplateID,
                             ecpt.SiteFoldersID
                        from [dbo].[ECardPartTemplate] ecpt, [dbo].[ECardPart] ecp
                        Where ecpt.ECardPartID = ecp.[ID] AND
                              ecp.SiteContentiD = @SourceID;