spClone_Polls

Parameters

Parameter	Parameter Type	Mode
@PKCloneID	int	IN
@PKCloneFromID	int	IN
@CurrentUsersID	int	IN

Definition

Copy



CREATE      PROCEDURE spClone_Polls
(
      @PKCloneID        int,
    @PKCloneFromID  int,
    @CurrentUsersID int
)

AS
    declare @SitePollAnswersID int
    declare @newGuid uniqueidentifier
    SET @newGuid = NEWID()

INSERT INTO SitePolls
(
    ID,
    ClientSitesID,
    LinkText,
    Question,
    RandomizeAnswers,
    AttributeTypesID,
    LastActivityDate,
    Closed
)
select
    @PKCloneID,
        ClientSitesID,
    LinkText,
    Question,
    RandomizeAnswers,
    AttributeTypesID,
    NULL,
    '0'

from SitePolls where [ID] = @PKCloneFromID

insert Into SitePollAnswers
(    SeqNbr,
    SitePollsID,
    Answer
)
Select     SeqNbr,
    @PKCloneID,
    Answer
From SitePollAnswers where SitePollsID = @PKCloneFromID

exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1