• 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
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...