USP_DATALIST_EMAIL_INVALIDACCOUNTS

        CREATE procedure dbo.USP_DATALIST_EMAIL_INVALIDACCOUNTS
        (
          @ISBLACKLISTED integer = null,
          @DATERANGE integer = null
        )
        as
            set nocount on;
          begin
            declare @DATECHECK date;
            declare @CURRENTDATE date = convert(date, getutcdate());
            set @DATECHECK = 
            case 
              when @DATERANGE = 0 then
                @CURRENTDATE
              when @DATERANGE = 1 then
                convert(date,dateadd(d,-7,@CURRENTDATE))
              when @DATERANGE = 2 then
                      convert(date,dateadd(d,-30,@CURRENTDATE))
            end;


            if @ISBLACKLISTED is null
            begin
              if @DATECHECK is null
              begin
                select ID, [ADDRESS], FAILEDMESSAGE, dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(DATEPROCESSED), FAILEDATTEMPTS, ISBLACKLISTED
                    from EMAILINVALIDRECIPIENT
                    order by DATEPROCESSED desc;
              end
              else
              begin
                select ID, [ADDRESS], FAILEDMESSAGE, dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(DATEPROCESSED), FAILEDATTEMPTS, ISBLACKLISTED
                    from EMAILINVALIDRECIPIENT
                  where DATEPROCESSED > @DATECHECK
                    order by DATEPROCESSED desc;
              end
            end
            else
            begin
              if @DATECHECK is null
              begin
                select ID, [ADDRESS], FAILEDMESSAGE, dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(DATEPROCESSED), FAILEDATTEMPTS, ISBLACKLISTED
                    from EMAILINVALIDRECIPIENT
                  where ISBLACKLISTED = cast(@ISBLACKLISTED as bit)
                    order by DATEPROCESSED desc;
              end
              else
              begin
                select ID, [ADDRESS], FAILEDMESSAGE, dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(DATEPROCESSED), FAILEDATTEMPTS, ISBLACKLISTED
                    from EMAILINVALIDRECIPIENT
                  where ISBLACKLISTED = cast(@ISBLACKLISTED as bit)
                    and DATEPROCESSED > @DATECHECK
                    order by DATEPROCESSED desc;
              end
            end
          end