USP_GET_MESSAGES_SEEN_BY_USER_ID

Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTUSERID	int	IN

Definition

Copy



create procedure dbo.USP_GET_MESSAGES_SEEN_BY_USER_ID
(
    @CLIENTUSERID INT
)
as
begin
    SELECT 
        [BANNERMESSAGEID]      
    FROM 
            [dbo].[CLIENTUSERSBANNERMESSAGESSEEN]
    WHERE
            [CLIENTUSERID] = @CLIENTUSERID
end