USP_ADD_MESSAGE_SEEN_BY_USERID

      Create procedure dbo.USP_ADD_MESSAGE_SEEN_BY_USERID(
      @MessageID uniqueidentifier,
      @CLIENTUSERID int
      )
      as
      begin

      declare @CHANGEAGENTID UNIQUEIDENTIFIER;
      exec dbo.Usp_changeagent_getorcreatechangeagent @CHANGEAGENTID OUTPUT;

      declare @DATE datetime
      set @DATE = Getdate()

      INSERT INTO [dbo].[CLIENTUSERSBANNERMESSAGESSEEN]
                 ([BANNERMESSAGEID]
                 ,[CLIENTUSERID]
                 ,[ADDEDBYID]
                 ,[CHANGEDBYID]
                 ,[DATEADDED]
                 ,[DATECHANGED])
           VALUES
                 (@MessageID
                 ,@CLIENTUSERID
                 ,@CHANGEAGENTID
                 ,@CHANGEAGENTID
                 ,@DATE
                 ,@DATE)
      end