|
|
-
Brad Schulz Commented 3 Years ago through Blogs | 1 Point
Just a quick note on your last example... it looks like the output was from a CASE expression that checked for Order_ID=4, not 3....
|
-
Brad Schulz Commented 3 Years ago through Blogs | 1 Point
Just a quick note on your last example... it looks like the output was from a CASE expression that checked for Order_ID=4, not 3....
|
-
Brad Schulz Posted 3 Years ago through Blogs | 10 Points
This is a continuation of my previous blog post, Delimited String Tennis Anyone?, wh...
|
-
Brad Schulz Posted 3 Years ago through Blogs | 10 Points
This is a continuation of my previous blog post, Delimited String Tennis Anyone?, which playfully talked about a virtual T-SQL Tennis match… a friendly rally back and forth between SQL Server MVP Adam Haines and myself in discussing methods of shredding...
|
-
Brad Schulz Posted 3 Years ago through Blogs | 10 Points
In my previous blog entry, I described in detail how you could u...
|
-
Brad Schulz Posted 3 Years ago through Blogs | 10 Points
In my previous blog entry, I described in detail how you could use the FOR XML clause to create a column with a comma-separated list of entries acquired from rows in a table somewhere. In this article, we will do the opposite… We will take a comma-sep...
|
-
Brad Schulz Posted 3 Years ago through Blogs | 10 Points
SQL Server MVP Adam Haines and I have been going back and forth for months in our blogs on the subject of creating and splitting a delimited string… it’s...
|
-
Brad Schulz Posted 3 Years ago through Blogs | 10 Points
SQL Server MVP Adam Haines and I have been going back and forth for months in our blogs on the subject of creating and splitting a delimited string… it’s been kind of a virtual T-SQL Tennis match… not a competition, but rather a friendly rally, knocking...
|
-
Brad Schulz Posted 3 Years ago through Blogs | 10 Points
It seems like the most frequently-asked question on the MSDN T-SQL Forum is how to put together a column that contai...
|
-
Brad Schulz Posted 3 Years ago through Blogs | 10 Points
It seems like the most frequently-asked question on the MSDN T-SQL Forum is how to put together a column that contains a list of some kind.
For example, take a look at the Northwind database. There’s a Categories table and a Products table. We&r...
|