USP_SIMPLEDATALIST_FAF_COMMUNICATIONS_LOG

create procedure dbo.USP_SIMPLEDATALIST_FAF_COMMUNICATIONS_LOG
(
  @EMAILJOBRECIPIENTID int = null
)
as
        SELECT FC.ID as VALUE
    FROM dbo.emailjob_recipient EJR (NOLOCK)
    INNER JOIN dbo.FAFCOMMUNICATIONSLOG FC (NOLOCK)
    ON EJR.EmailJobID = FC.EMAILJOBID
    WHERE EJR.ID = ISNULL(@EMAILJOBRECIPIENTID,-1)