I just did a deep dive on that code.  ANSI NULLs are the key there!  Really cool code!  Thanks, again, Drew.  Do you have a link where Itzik provides this...

I agree with Drew... the code he posted does a single scan and not a scan with a wad of seeks.

Thanks for the feedback.

Says the guy with the critique...

@usererror ,

I actually wouldn't be surprised that someone posted such a thing somewhere.  😀  That's why I posted the code to prove what it actually does.  It was just easier...

DUDE!!!!  CHANGE THE VALUE OF THE STRING FOR THE BLOODY @OBJECTNAME VARIABLE TO THE SCHEMA NAME AND OBJECT NAME FOR...

Here's your original data as a Temp Table to persist the test data to make "playing" easier...

  DROP TABLE IF EXISTS #Temp;
GO
 CREATE TABLE #Temp
 ...

Using the following code, please note that the DATE and DATETIME datatypes behave exactly the same way when it comes to blanks and NULLs.  Run the following code and see.

Please see my reply on the thread that spawned this need at

https://www.sqlservercentral.com/forums/topic/missing-datafinding-the-root-problem/page/2#post-4072000

Thank you for the feedback, Daniel.  I appreciate it.

Yes, i am trying to find out which stored procedure or table. I was just given this task and thrown in the deep end. I am still learning the...

You should try it and see. "One good test is worth...

With the understanding that I've never used Power BI, are you suggesting that Power BI cannot get data directly from SQL Server without having to use a language like...

Your function is grouping by columns from that table and it's empty???  Do you suppose...

To be honest, this sounds like a setup for a SPAM update.  If you're not a spammer, go back to...