Hierarchy Data

The hierarchyid data type in SQL Server 2008

In regards to the hierarchyid data type in SQL Server 2008, what is the solution if the parent node gets deleted?

Sorting hierachy data alphabetically in SQL Server 2005

I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish...

Help needed for date dimension which is not rolled up properly.

I'm new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year - smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname - Varchar...