Hi Jeff,

Ik don't understand the BuildTestHierarchy stored procedure.

In my database I get the Employee table, but I don't see any column of type hierarchyid.

Do I have to do some additional...

Although you will find views, rules, defaults, etc. with the word "order" in them, you may not find ALL views, rules, etc. with the word "order".

For larger objects the text...

Another variaton, using the MONTH function:

SELECT [Month] = DATENAME(mm,SomeDateTime),

Amount = SUM(SomeAmount)

FROM #MyHead

WHERE SomeDateTime >= '2010'...