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