USP_DATALIST_WPPARSINGERROR

CREATE procedure dbo.USP_DATALIST_WPPARSINGERROR
    (
        @JOBIDPARAMETER nvarchar(100) = null,
        @DATECODE smallint = 2
    )
as
    set nocount on;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    declare @STARTDATE datetime;
    select @STARTDATE = 
        case @DATECODE                        
            when '1' then --Today 

                dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,0,@CURRENTDATE))
            when '2' then --Last 7 days

                dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-6,@CURRENTDATE))
            when '3' then --Last 30 days

                dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-29,@CURRENTDATE))
            when '4' then --Last 90 days

                dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-89,@CURRENTDATE))
            when '5' then --Last 6 months

                dbo.UFN_DATE_GETEARLIESTTIME(dateadd(month,-5,@CURRENTDATE))
            when '6' then --Last 12 months

                dbo.UFN_DATE_GETEARLIESTTIME(dateadd(month,-11,@CURRENTDATE))
        end

select
    WPPARSINGERROR.ID,
    SUBSTRING(WPSEARCHHISTORY.JOBID,18,9) as JOBID,
    case WPSEARCHHISTORY.SEARCHTYPECODE
                            when 0 then CONSTITUENT.NAME
                            when 1 then RESEARCHGROUP.NAME
                            when 2 then 'Data Refresh'
                        end as NAME,
    WPPARSINGERROR.DATATABLENAME, 
    WPPARSINGERROR.LOCATION,
    WPPARSINGERROR.ROWERROR,
    WPPARSINGERROR.DATEADDED,
  WPPARSINGERROR.PARENTID,
  coalesce(WPPARSINGERROR.ERRORROWIDENTIFIER, '')
from 
    WPPARSINGERROR
left outer join 
    WPSEARCHHISTORY on WPSEARCHHISTORY.ID = WPPARSINGERROR.WPSEARCHHISTORYID
left outer join
    CONSTITUENT on CONSTITUENT.ID = WPSEARCHHISTORY.CONSTITUENTID
left outer join
    RESEARCHGROUP on RESEARCHGROUP.ID = WPSEARCHHISTORY.RESEARCHGROUPID
where
    (nullif(@JOBIDPARAMETER, '') is null or (WPSEARCHHISTORY.JOBID like '%' + @JOBIDPARAMETER + '%')) and
    (not @DATECODE in (1,2,3,4,5,6) or (WPPARSINGERROR.DATEADDED >= @STARTDATE))