Using a CTE in a Function to Split Up a Query String
The question came up as to how do I parse a query string using TSQL. So here you go, using a common table expression, and… Read More »Using a CTE in a Function to Split Up a Query String
The question came up as to how do I parse a query string using TSQL. So here you go, using a common table expression, and… Read More »Using a CTE in a Function to Split Up a Query String
One of the common questions that comes up in my CTE class/presentation asks can you use the CTE inside of a function or stored procedure.… Read More »Using a CTE to Split a String Into Rows
After my CTE presentation at SQL Saturday 108 in Redmond, I was asked many questions, and received several great suggestions from people. Based on that… Read More »CTE Hierarchy compared to the alternative