TheServerSide.Net has a nice article on performing Hierarchical queries using CTEs on SQL Server 2005.
http://www.theserverside.net/articles/showarticle.tss?id=HeirarchicalQueries
Hierarchical Queries in SQL Server 2005
New on Geeks with Blogs
- Your Customers Build the Features Now
I let a tool I liked sit dead for a year rather than build the features I wanted. An MCP server meant I never had to, and your customers can do the same to your product.
- Get the Size of a Directory in Linux the Easy Way
du -sh for the quick answer, ncdu for the cleanup, df for the disk itself: every command for checking directory size in Linux, plus why du and df never agree.
- Vim Search and Replace: The Ultimate Guide
One :%s command replaces every match in a file before a find dialog would even open. The Vim substitute patterns worth the muscle memory: flags, ranges, capture groups, and multi-file edits.
- Because of AI, You Need a New Development Team
Your existing team is buried in the complexity of your existing product. AI rewards the team with a blank slate. Most companies don't have one.