spGetMessages_Trash

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

    -- Get Sent Messages Trash

    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 = 1

    UNION ALL 

    -- Get Received Messages Trash

    SELECT 
    2 'MessageType',
    i.ID 'MessageID',
    i.Viewed
    FROM [Message] i
    WHERE i.OwnerID = @OwnerAccountID
    AND i.OwnerID = i.RecipientID
    AND i.Sent = 0
    AND i.Deleted = 1

    END