RE: Problem with creating XML file by nesting functions

SSC Guru

Points: 61136

March 27, 2015 at 2:37 am

Not to take anything away from what joe put together for you I bet if you put Eirikur's solution into an inline table valued function it would perform much better than any scalar UDF that produces the same XML.

Note this article:

How to Make Scalar UDFs Run Faster (SQL Spackle)[/url]

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001