<<

Think of a book and imagine that the page numbers are the clustering key. I cut the pages out of a book, mix them up and drop them on the...

When you discard query results you dont get any information back to the client (SSMS).

For those interested in the performance impact of each concatenation method, I blogged about this some time ago. The XML method consistently does better for reads and IO. I...

My guess is stuff. Anytime the...

joe.strollo (10/14/2009)

---

I use the method below for concatenating multiple values into one. Wouldn't this work?

-- Fill a temporary table variable with the data in the example

DECLARE @TempTable TABLE

(idx...

Tom Winter (10/14/2009)

---

I've been using Solution 2, FOR XML PATH, for a while with good results. I use STUFF as SSChampion mentions to get rid of the extra separator.

One other...

Great post Jeff!!! 🙂

One thing to note on performance. The PIVOT operator is actually processing a cross tab query under the hood, so the performance is identical for...

For...

Referring to the last post about the XML FOR PATH functionality, this is very interesting, but it has one issue: when you have the "" characters in the string, it...

I too have faced this problem. The easiest method I have found is to set the string variable to an xml variable. You can select the variable and...

Scott Jacobson (7/20/2009)

---

Great article David!

David mentions that he discovered these in training materials for SQL 2008. Were INTERSECT and EXCEPT not introduced in SQL 2005 and as such, just...

Jeff,

In some cases intersect is easier to use than inner join, if you want to compare resultsets. ...

Good job Jonathan 🙂

Great job Wayne! This article is definitely a good read. 🙂

Great article Jonathan! The article is easy to read, informative, and concise.

Great Job.