Monday, March 14, 2005
EmpHierarchy Table Script
This is the table script used in the examples for Path enumeration using Prime Number Products.
CREATE TABLE dbo.EmpHierarchy(EmpId int PRIMARY KEY,
EmpName VARCHAR(50),
ManagerId int,
HKey bigint UNIQUE,
Path bigint)
This is the table script used in the examples for Path enumeration using Prime Number Products.
CREATE TABLE dbo.EmpHierarchy(EmpId int PRIMARY KEY,
EmpName VARCHAR(50),
ManagerId int,
HKey bigint UNIQUE,
Path bigint)
