USP_GET_LISTS_BY_EMAILID

     CREATE procedure dbo.USP_GET_LISTS_BY_EMAILID
    (
      @EmailID int 
    )
    as
    begin
        set nocount on

    select 
        EL.ID as ListId,
        case when El.DataSourceID =301 then 'Direct Marketing Email List'
        else EL.Name END as ListName,
        case when El.DataSourceID =301 then dbo.UFN_GETBBDMEMAILLISTRECEIPIENTSCOUNT(@EmailID)
        else EL.AcquiredRecordCount end as RecordCount,
        EL.DataSourceID
    from    dbo.Email_EmailList EEL
    inner join dbo.EmailList EL on EEL.EmailListID = EL.ID
    where EEL.EmailID = @EmailID and EEL.IsTest = 0 

    end