Tree problems have plagued SQL Server db programmers for a long time. The new user defined function feature in SQL Server 2000 provides a relief to this dilemma. In this article we demonstrate an approach to solving the employee supervisor tree problem using a recursive user-defined SQL Server 2000 function call.
Pulse is a brand-new section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community. We recommend checking out Pulse in a modern web browser, such as Internet Explorer 7+, Firefox 3+, Safari 4+, Opera 10+, or Chrome.