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