spGetMessages_Draft

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

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

    END