• subscribe
December 20, 2000 12:00 AM

Test Your Recursion Powers!

SQL Server Pro
InstantDoc ID #16360

To test your understanding of recursion and user-defined functions (UDFs), solve the following puzzle: Can you implement the function ufn_GetSubtree by using a recursive algorithm? Note that you aren't required to return the lvl and path columns, rather just employee details of the whole subtree under a given manager. To find the answer to this puzzle, see the sidebar "Answer to Recursion Challenge," available online at http://www.sqlmag.com, InstantDoc ID 16197.



ARTICLE TOOLS

Comments
  • Anonymous User
    7 years ago
    Jan 11, 2005

    test

You must log on before posting a comment.

Are you a new visitor? Register Here