USP_INSERT_DirectoryMessageStats

Parameters

Parameter	Parameter Type	Mode
@UserName	nvarchar(50)	IN
@PageID	int	IN
@PartID	int	IN
@Subject	nvarchar(255)	IN
@SenderEmail	nvarchar(255)	IN
@Message	nvarchar(400)	IN

Definition

Copy



create procedure USP_INSERT_DirectoryMessageStats
  @UserName nvarchar(50),    
  @PageID int,
  @PartID int,
  @Subject nvarchar(255),
  @SenderEmail nvarchar(255),
  @Message nvarchar(400)
as
begin
   declare @CHANGEAGENTID uniqueidentifier;
   exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
   INSERT INTO [dbo].[DIRECTORYMESSAGESTATS]    

       ([USERNAME] , [PAGEID], [PARTID], [SUBJECT], [SENDEREMAIL], [MESSAGE], [ADDEDBYID], [CHANGEDBYID])    

    VALUES    

       (@UserName , @PageID, @PartID, @Subject, @SenderEmail, @Message, @CHANGEAGENTID, @CHANGEAGENTID)  
   end