[dbo].[MssWebGetRecentlyUsedEmailAddresses]
CREATE PROCEDURE [dbo].[MssWebGetRecentlyUsedEmailAddresses] @inSysUserId INT
AS
BEGIN
SET NOCOUNT ON;
SELECT TOP 100
RecipientName,
EmailAddress
FROM RecentlyUsedEmailAddress
WHERE SenderSysUserFId = @inSysUserId
ORDER BY LastUsedOn DESC;
END;
GO
GRANT EXECUTE ON [dbo].[MssWebGetRecentlyUsedEmailAddresses] TO [MssExec]
GO