Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Aggregation and Heirarchy Data type Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 11:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 5:32 PM
Points: 35, Visits: 175
I want to store an organization Hierachy structure in a table using the Hierarchy data type i've just discovered.
Against each level of the organization are numeric values that i want to manipulate. What' i'm not sure of is if there are new functions to assist me in getting aggregations that group on the Hierarchy nodes.

For example. How would i get a sum/total of a numeric field from a table with a Hierarchy datatype if i wanted aggregation to occur 2 nodes from the top ? Do i use group by or rollup ? Or is there now some better cleaner way to do this ?



Post #1435263
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse