Did you ever get to the bottom of this issue? I'm experiencing the same problem with a SQL 2014 installation. Interestingly a clustered install works just fine, but a standalone...

Looks to me like you are misunderstanding the concept of what a user hierarchy is. What you present is certainly a non-standard way of structuring a dimension and hierarchies. What...

It shouldn't need to cursor through the fields either.

Below is a version I'd used in the past. I've just updated it for SQL 2005 and 2008. It's not got lot's...

Although I agree that there is merit in this technique (as I've used it myself on previous projects). I would say this "quick and dirty" attempt is like re-inventing the...

Nicely done. However I would look to apply the the filter condition as early as possible, because on a 1 million row table, the procedure will cursor over all 1...