Hierarchy data Questions

1

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?

Answer Question   |  February 25, 2009  8:52 PM
Hierarchy data, SQL Server 2008, SQL Server Data Types
2,585 pts.

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 this?

Answer Question   |  September 9, 2008  8:02 PM
Hierarchy data, Sorting, SQL Server 2005
2,585 pts.

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 (Eg: Tuesday), quarter -int(Eg: 1) I build a dimension using [...]

Answer Question   |  June 9, 2008  6:15 PM
Hierarchy data, SQL, SSAS
asked by:
5 pts.

1