Craig Farrell (11/1/2010)

---

jamesniesewand (11/1/2010)

---

Personally I felt I was missing something with CTEs, and that "felt" like a Eureka moment for me (I've only just moved up to 2008 from 2000,...

Craig Farrell (11/1/2010)

---

EDIT: I cross posted with Wayne. 🙂 I took his code and checked the plans against mine. Unindexed, and with this tiny dataset, they're about even...

Great, I'm glad it's working right. Thanks for posting the DML/DDL to produce...

Please go back to the link that Craig pointed you to, and read that article (it's the same...

And what happens if the bottom 5 people have the worse wage, and what you want is the 6th person (2nd lowest wage)? You might want to use the RANK()...

;WITH CTE AS

(

SELECT t.ExampleTableID,

t.ExampleProduct,

t.ExampleValue,

RN = RANK() OVER (PARTITION BY...

I see no reason why your variables in the c.u.r.s.o.r. are not being updated - would you mind posting the entire procedure for us to look at?

Also, if you can...

I'm glad that I...

If you can use freeware, http://www.ssmstoolspack.com has this feature.

declare @field varchar(5);

set @field = 'class';

declare @sqlcmd varchar(max);

SET @sqlcmd = '

SELECT ' + @field + ' = STUFF((SELECT '','' + ' + @field + '

...

Congratulations Gail!

It still has to be declared before it is referenced... if you move the if/declare block to the end of the code, it does generate an error.

Jeff - what do you mean by "overlapping" dates, and how does this differ from determining gaps/islands?

(If it's different, we probably ought to add one for each of those.)

WayneS (10/28/2010)

---

Jeff Moden (10/28/2010)

---

Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll...

Jeff Moden (10/30/2010)

---

Kevin Bullen (10/30/2010)

---

Question for the experts.

In reviewing code written by a contractor, they declare a table variable inside a cursor, but it is never used. The cursor...