We are working on SQL 2008 for a new project with the intent to leverage the new data types , in this case especially the HIERARCHYID data type. One of the stored procedures we created had a parameter of type HIERARCHYID . The code that calls the stored procedure was something like this. SqlHierarchyId...