USP_DATALIST_PARTICIPANTEMAILTEMPLATEDETAIL

CREATE procedure dbo.USP_DATALIST_PARTICIPANTEMAILTEMPLATEDETAIL(@ID uniqueidentifier)
as
    set nocount on;

      SELECT 
            PT.[ID],
            PT.[NAME],
            PT.[DESCRIPTION],
            PT.[CONTENTHTML],
            PT.[SUBJECT],
            PT.[CONTACTTYPE],
            0 AS [ADMINTEMPLATE],
            -1 AS EMAILTEMPLATEID,
            PT.DATEADDED,
            PT.AVAILABLEASLETTER
         FROM 
            dbo.PARTICIPANTEMAILTEMPLATE PT
            WHERE PT.ID = @ID