Recursion and FOR XML
Kent just published an example on how to get recursive XML structures (think employee-manager). The new version of the FOR XML whitepaper actually contains a section with such a sample (I need to get the MSDN team to publish it). I don't want to spoil the content of the whitepaper here, but I would like to add some comments to Kent's approach (I am sending some comments on minor coding issues to Kent directly).