I came across this example when preparing my CTE presentation a while back. Which produces the following output. Download my book for FREE when you… Read More »Using a CTE in a Function to Split Up a Database Connect 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
Last month I posted another CTE blog entry Using a CTE to Split a String Into Rows with Line Numbers. Since then I have used it… Read More »VARCHAR diff function
Last year while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String… Read More »Using a CTE to Split a String Into Rows with Line Numbers
I came across this example when preparing my CTE presentation for SQL Saturday in Portland OR in 2 weeks. Which produces the following output.
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