How do I Join Calendar table with other tables with sparse dates

I would try for a moment to forget about Calendar table and write normal JOINS for other tables as you would do to get information from them. Put that select statement into cte (derived table) and then from the Calendar table LEFT JOIN with that derived table or cte.

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles