spGetMessages_Sent

Parameters

Parameter Parameter Type Mode Description
@OwnerAccountID int IN

Definition

Copy



        CREATE PROCEDURE [dbo].[spGetMessages_Sent]
        (
            @OwnerAccountID int
        )
            AS
            BEGIN

            SELECT 
            1 'MessageType',
            o.ID 'MessageID',
            o.Viewed
            FROM [Message] o
            WHERE o.OwnerID  = @OwnerAccountID
            AND o.OwnerID = o.SenderID
            AND o.Sent = 1 AND o.Deleted = 0
            AND (o.MessageFolderID = 0 OR o.MessageFolderID IS NULL)
            ORDER BY o.SentDate DESC

            END