Problem with recursive CTEs is that they are very slow in comparison to the XML method.

Please see here[/url] for a much better article on the subject.