michael vessey (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql...

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql server, you certainly do not...

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql server, you certainly do not want to go to Oracle...

I copied and pasted the function from the article but it wouldn't compile. There were some CHAR(63) in there instead of CHAR(32) (spaces)

If you are using a recursive CTE then you will need a to have a UNION ALL.

DECLARE @EmpId int

SET @EmpId = 5

;WITH CTE AS

(

SELECT *

...

We use SAN with massive amounts of memory installed on them. This seems to be a whole different kettle of fish. The bottlenecks move from the disk to other areas...

michal.lisinski (4/2/2012)

---

Jonathan AC Roberts (4/2/2012)

---

michal.lisinski (4/2/2012)

---

Imho

SELECT DISTINCT CustomerID

FROM [#Purchase]

WHERE (ProductCode IN ('A','B')) AND (CustomerID NOT IN

...

michal.lisinski (4/2/2012)

---

Imho

SELECT DISTINCT CustomerID

FROM [#Purchase]

WHERE (ProductCode IN ('A','B')) AND (CustomerID NOT IN

...

codebyo (3/29/2012)

---

One question though:

Wouldn't the query below present the same results?

SELECT

CustomerId

FROM Purchase

WHERE ProductCode IN ('A','B', 'C')

GROUP BY CustomerID

having sum(case when ProductCode = 'C' then 1 else 0...

mister.magoo (3/29/2012)

---

Hi Jeff,

Great Spackle, thanks!

In my tests, using your code to build a million row test, I found this method to be twice as fast for the same logical reads.

SELECT...

Just to end arguments over performance I tried this:

DECLARE @StartTime datetime

DECLARE @x int

DECLARE @y varchar(20)

DECLARE @MaxIterations int

SET @MaxIterations = 10000

SET @StartTime = GETDATE()

DECLARE @i int

SET @i = 0

WHILE @i <...

mtassin (3/13/2012)

---

andrew.diniz (3/13/2012)

---

That's...

Jeff Moden (3/13/2012)

---

Comparatively speaking, it's a large issue especially if someone uses it for something else, Jonathan. Please see the following article...

For the purpose of displaying 12 values the use of a recursive CTE is fine. Performance won't be an issue. You are using the CTE to generate numbers 1 to...

drew.allen (3/5/2012)

---

Jonathan AC Roberts (3/5/2012)

---

drew.allen (3/5/2012)

---

The original question was about taking multiple values and storing them in a...