[dbo].[EmailApiGetOutgoingEmailInlineAttachments]
CREATE PROCEDURE [dbo].[EmailApiGetOutgoingEmailInlineAttachments]
@inOutgoingEmailIds IntList readonly
AS
begin
set nocount on
select
OutgoingEmailId = OutgoingEmailInlineAttachment.OutgoingemailFID,
Content = OutgoingEmailInlineAttachment.Content,
ContentId = OutgoingEmailInlineAttachment.ContentId,
MediaType = OutgoingEmailInlineAttachment.MimeType
from @inOutgoingEmailIds Ids
inner join OutgoingEmailInlineAttachment on Ids.Item = OutgoingEmailInlineAttachment.OutgoingEmailFID
end
GO
GRANT EXECUTE ON [dbo].[EmailApiGetOutgoingEmailInlineAttachments] TO [MssExec]
GO