Recent IT Questions

1 - 2 of 2
<<PREVIOUS 1 NEXT>>

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


1 - 2 of 2
<<PREVIOUS 1 NEXT>>