USP_DATALIST_GET_EMAILJOB_CONTENTHTML

create procedure dbo.USP_DATALIST_GET_EMAILJOB_CONTENTHTML(@EmailJob_MERGEID uniqueidentifier)
as
    set nocount on;

    select ej.ContentHTML
    from dbo.EmailJob ej
    inner join dbo.EmailJob_Recipient ejr on ejr.EmailJobID = ej.ID
    where ejr.MERGEID = @EmailJob_MERGEID