It's going to be a busy fall for me, at least for a month or two. I'm really lucky to have been invited to speak at some fabulous conferences and user groups. September 23-24 (Ottawa is the 23rd and Montreal the 24th. I don't have location...
While preparing for a SQL PASS a year or two ago when I was doing a session about common table expressions, I had endeavored to come up with an extremely simple recursive CTE. Unfortunately, I wasn’t creative enough at the time to come up with anything...