spClone_NewsReader

Parameters

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

Copy


            CREATE Procedure [dbo].[spClone_NewsReader]
            (
                @PKID int output,
                @CloneContentID int,
                @ClonedContentID int,
                @CurrentUsersID int
            )
            AS

            DECLARE @NewGuid uniqueidentifier
            SET @NewGuid = NEWID()

            INSERT INTO NewsReaders
            (
                SiteContentID,
                NewsReaderURL,
                Guid,
                ShowDate,
                ShowGraphic,
                HeadlineOnly,
                PagedOutput,
                ArticlesPerPage,
                MaxHeadlines,
                NewsReaderAuthType,
                NewsReaderUsername,
                NewsReaderPassword
            )
            Select
                @CloneContentID,
                NewsReaderURL,
                @NewGuid,
                ShowDate,
                ShowGraphic,
                HeadlineOnly,
                PagedOutput,
                ArticlesPerPage,
                MaxHeadlines,
                NewsReaderAuthType,
                NewsReaderUsername,
                NewsReaderPassword
             FROM NewsReaders
             WHERE SiteContentiD = @ClonedContentID

            SELECT @PKID = @@Identity

            exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1