lnoland (3/18/2015)

---

I have often found that CTE's allowed me to increase performance though I can only speculate as to why. We have some big, poorly designed tables which can...

The recursive cte should never be used if you are concerned with performance.

The recursion resolves row by row instead of sets. A while loop with temp tables would...

I did an article on using a long parameter list instead of trying to write a home-made parser in T-SQL or contaminating the schema with XML and CLR code. I...

no one able to find the massive thread ? link please !

I see what you are saying Jeff, but would you want to do validation if the application did not allow the end user to send invalid data? perhaps using a...

Hate to bump an old thread, but it is the google result I found for BOM recursive query.

I wound up using your example on that other thread Jeff,