Maybe this?
https://www.red-gate.com/simple-talk/blogs/string-comparisons-in-sql-edit-distance-and-the-levenshtein-algorithm/

Thanks for the sample data. The only thing missing now is an explanation of what you really want - like a sample result that you're trying to return..??

Please please please don't post pictures of your database. Those are worthless. I can't copy & paste into SSMS and run it.  So since I don't have real tables, I'll...

Oh fun!
This sounds like it's the end part of some dynamic SQL statement, so you need to track down exactly what query is being built, so you know the...

the other option is to OUTER join to your Calendar table.
...
FROM Calendar c LEFT JOIN Sales s
   ON c.CalendarDate = s.SaleDate

because that forces a value...

Bart vs. Australia, anyone?

Take this with a grain of salt, because I'm a SQL Server dummy, but I'd probably create a cursor to loop over the tables in your database that you want...

SELECT TOP 2 PERCENT :<column list>
FROM ...

If all you want is the previous value, then why not just use LAG()?  For the first value in the PARTITION BY clause, it will be NULL. For all others,...

Did you rebuild the indexes after the shrink? That would do it.

Why not just add a sort of phony column for each of the two sets. For the book income, set the value = 1 and for the other set the...