Recursive Common Table Expressions in SQL Server for working with a hiearchy

Just wanted to throw in a quick write up about common table expressions (CTE) in sql server. There are plenty of good and complete write-ups on ctes floating around teh tubes these days but I wanted to address my paticular issue, if nothing else so I don’t forget about them. Imagine you have a hiearchy […]