https://learn.microsoft.com/en-us/answers/questions/1841306/materialized-view-and-left-join?page=1&orderby=Helpful&comment=answer-1619558#newest-answer-comment https://learn.microsoft.com/en-us/answers/questions/1840792/sql-server-2022-launchpad-how-to-eliminate-errors?page=1&orderby=Helpful&comment=answer-1619216#newest-answer-comment