spClone_SiteVolunteerOps

Parameters

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

Copy


            CREATE PROCEDURE dbo.spClone_SiteVolunteerOps
            (
                @PKID                int output,
                @CloneContentID        int,
                @ClonedContentID    int
            )
            AS
            BEGIN
                BEGIN TRANSACTION

                INSERT INTO SiteVolunteerOps
                (
                    ContentID,
                    JobQueryID,
                    ConstituentCodeID,
                    EmailTemplateID,
                    VolunteerTypeID,
                    JobAttributesToDisplay
                )
                SELECT 
                    @CloneContentID,
                    JobQueryID,
                    ConstituentCodeID,
                    EmailTemplateID,
                    VolunteerTypeID,
                    JobAttributesToDisplay
                FROM SiteVolunteerOps
                WHERE ContentID = @ClonedContentID

                SELECT @PKID = @CloneContentID

                COMMIT TRANSACTION
            END