Skip navigation

Test Your Recursion Powers!

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 "Answer to Recursion Challenge."

TAGS: SQL
Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish