January 25, 2008 01:25 PM
Crystal-Clear Reporting on Hierarchical Data
Follow these 5 easy steps in Visual Studio—and forget the complicated self-joins
Rating:
(0)
SQL Server Magazine
InstantDoc ID #97789
Hierarchical data is hardly a new phenomenon
in the database world. Tables can contain data
that defines a parent-child relationship, such as
that between managers and employees in the Employees
table. Hierarchical data within a table is defined by a primary
key-foreign key relationship. In the Employees table,
for example, the table’s primary key, Employee_Id, has a
foreign key relationship with the Reporting_Manager_Id
column, creating a parent-child relationship between ...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: