spClone_EmailList

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@NewName	nvarchar(510)	IN
@NewGuid	uniqueidentifier	IN

Definition

Copy



        CREATE     PROCEDURE [dbo].[spClone_EmailList]
(
      @PKID        int OUTPUT,
    @CurrentUsersID     int,
    @NewName    nvarchar(510),
      @NewGuid    uniqueidentifier
)

AS

INSERT INTO [dbo].EmailList ( 
    Guid,
    [Name],
    [Description],
    OwnerID,
    Type,
    Options,
    Origin
) SELECT               
    @NewGuid,
    @NewName,     
    Description,
    @CurrentUsersID,
    Type,
    Options,
    Origin
FROM        
    EmailList
WHERE       
    ID = @PKID


SELECT  @PKID = @@Identity

exec spAuditThis @CurrentUsersID, 1, @NewGuid, 12