Using your data, and building off of this article (man, that really is an awesome article, isn't it???), you end up with:

WITH cte AS

(

SELECT ...

Just 9 out of 10 applicants. Maybe higher.

BL0B_EATER (11/3/2015)

---

Going to PASS is on my list of objectives but due to lack of company interest in me I cant afford it as I have decided to go to...

yb751 (10/29/2015)

---

Ed Wagner (10/29/2015)

---

yb751 (10/29/2015)

---

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but then I...

Thanks to all for the kind words of appreciation for this article - it makes it all worthwhile. I'm glad that it has been so well received, and even more...

Henn,

I'm afraid that I just don't understand why you're going through the effort to create a sequence, just to have an incrementing number. Why not just use the ROW_NUMBER function?

And the guilty service was???

Sean Lange (10/13/2015)

---

Brandie Tarvin (10/13/2015)

---

My cats are always happy to see me. They just get irked when I ignore them to do MY thing instead of worshipping the ground they...

Brandie Tarvin (10/13/2015)

---

It took me a while to figure out the reason why my laptop power supplies kept dying (and I had to keep buying new ones) was that she...

BrainDonor (10/9/2015)

---

I've just about completed an article for publication on SSC, describing the behaviour of explicit transactions and would appreciate it if a couple of people could cast their eyes...

rodjkidd (10/7/2015)

---

SQLRNNR (10/7/2015)

---

rodjkidd (10/7/2015)

---

BrainDonor (10/7/2015)

---

rodjkidd (10/6/2015)

---

I can imagine!

So for Summit will you get to Seattle in time for the meet and greet / official opening of Summit on the Tuesday...

GilaMonster (10/6/2015)

---

#gloat Company's paying for the trip to the US. If I was speaking at Pass Summit, they'd be paying for hotel too. They paid for my trip to the...

BWFC (10/6/2015)

---

Michael L John (10/5/2015)

---

Lynn Pettis (10/5/2015)

---

Ed Wagner (10/5/2015)

---

You know, I think the Silver Spoons are going to need to be reordered - I'd suggest at least a case. ...

Robin,

Did you check the power saving settings that Jason mentioned just a couple of posts ago?

I know many places build SQL Server instances with this many tempdb data...