Full threadiblaine·Typically I advise people to use CTE's for ad hoc queries and to avoid CTE's for production code. CTE's are easily abused.View on HN