spGetMessages_Custom

Parameters

Parameter Parameter Type Mode Description
@MessageFolderID int IN

Definition

Copy



        CREATE PROCEDURE [dbo].[spGetMessages_Custom]
            (
            @MessageFolderID int
            )
            AS
            BEGIN

            -- Get Sent Messages In Folder

            SELECT 
            1 'MessageType',
            o.ID 'MessageID',
            o.Viewed
            FROM [Message] o
            WHERE
            o.Deleted = 0
            AND o.MessageFolderID = @MessageFolderID

            END