I was looking into creating a nested set for a hierarchical structure to create a categories table for a web site on an MSSQL 2008 express database. I have been following this guide which was written for MySQL: I was looking into creating a nested set for a