USP_DATALIST_PARTICIPANTEMAILTEMPLATEWITHTASKDETAIL

CREATE procedure dbo.USP_DATALIST_PARTICIPANTEMAILTEMPLATEWITHTASKDETAIL
(
  @ID uniqueidentifier,
  @ADMINTEMPLATE bit
)
as
set nocount on;

if (@ADMINTEMPLATE = 1)
begin
    select 
        EVENTEMAILTEMPLATE.ID,
        EMAILTEMPLATE.SUBJECT,
        EMAILTEMPLATE.CONTENTHTML,
        EVENTEMAILTEMPLATE.FAFTASKID,
        FAFTASK.NAME as FAFTASKNAME,
        null as LASTDAYSENT,
        1 as ADMINTEMPLATE
    from dbo.EVENTEMAILTEMPLATE (nolock)
        inner join dbo.EMAILTEMPLATE (nolock) on EMAILTEMPLATE.ID = EVENTEMAILTEMPLATE.EMAILTEMPLATEID
        inner join dbo.FAFTASK (nolock) on FAFTASK.ID = EVENTEMAILTEMPLATE.FAFTASKID
    where
        EVENTEMAILTEMPLATE.ID = @ID
end
else
begin
    select 
        PARTICIPANTEMAILTEMPLATE.ID, 
        PARTICIPANTEMAILTEMPLATE.SUBJECT, 
        PARTICIPANTEMAILTEMPLATE.CONTENTHTML,
        PARTICIPANTEMAILTEMPLATE.FAFTASKID, 
        FAFTASK.NAME as FAFTASKNAME,
        PARTICIPANTEMAILTEMPLATE.DATECHANGED as LASTDAYSENT,
        0 as ADMINTEMPLATE
    from dbo.PARTICIPANTEMAILTEMPLATE (nolock)
    inner join dbo.FAFTASK (nolock) on FAFTASK.ID = PARTICIPANTEMAILTEMPLATE.FAFTASKID
    where 
        PARTICIPANTEMAILTEMPLATE.ID = @ID
end