For those who don't understand the addition of dates.
Datetime is stored internally as 2 integers: one for the date and one for the time. Each date has an...

Maybe something like this:

IF NOT EXISTS( SELECT * FROM @EntryPoint WHERE name IN( '<ALL>' , '<NONE>'))
   DELETE FROM #AllCases
   WHERE ISNULL(ColumnEntryPointName, '') NOT IN...

This is what I tried.

CREATE TABLE #Dates( SomeDate datetime2)

DECLARE @n int = 0;
WHILE @n < 10000
BEGIN
    INSERT INTO #Dates VALUES(SYSDATETIME())

American dates?

This appears to be a bug in SQL Server (or a feature?). It's easily corrected if you remove the derived table and use a direct query.

DECLARE...