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