SQL Tip: Recursive CTEs

[edit: March 2019] This was originally posted to my internal (to Microsoft) blog on Sep 28, 2012 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. Rather than rewrite this tip I'm leaving it as it was originally written. In this SQL Tip … Continue reading SQL Tip: Recursive CTEs