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...
View Answer
| Jul 1 2008 8:02 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Hierarchy data, Sorting
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...
Answer Question
| Jun 9 2008 6:15 PM GMT
| asked by
Sree1119
Hierarchy data, SSAS, SQL
