UMG Developer (5/6/2010)

---

I missed it just because of the physical order part... They are physically stored in the clustered order, maybe just not contiguously/in sequence. 😉 The BOL docs don't...

Am I right in thinking there are a more efficient ways of creating the test data?

Such as:

WITH NORBAR AS (

SELECT N FROM dbo.Tally

WHERE N < 500 )

INSERT INTO QOTD (Title,EmailAddress,DateSubmitted,Age)

SELECT...

This question must be clearing up common confusions - only 2% got it right so far - thats the worst ratio of correct answers I've seen on a QOTD

destification

(from my Dubya sat-nav voice "You have reached your destification")

Tell us more about your role as 'the BOFH' 😀

pontification

Chris Morris-439714 (4/23/2010)

---

GSquared (4/22/2010)

---

jcrawf02 (4/22/2010)

---

Grant Fritchey (4/22/2010)

---

jcrawf02 (4/21/2010)

---

Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛

And now for something completely different...

Any advice...

Check out this article http://www.sqlservercentral.com/articles/T-SQL/69717/

You should end up with something like

SELECT DATE, ROW_NUMBER() OVER(PARTITION BY Date ORDR BY Date) AS RN

EDSAC !

My word - that was ancient history when I started on ICL 1900s

Great suggestion - I had a feeling ranking/over/partition syntax would come in somewhere. I've never seen it used on a COUNT before.

Attached files show my code and your code together,...

lmu92 (4/22/2010)

---

Would you mind providing table DDL including some fake sample data and expected result?

Would help a lot folks like me that prefer to have something to play with /...

Yes, I had thought as much

My code is quite complex and I can't post it - for some reason the internet filters here won't let me - I'll...

Gianluca Sartori (4/22/2010)

---

Jack Corbett (4/22/2010)

---

Gianluca Sartori (4/21/2010)

---

I've seen even worse things in my app (Visual Basic):

Public const SC AS String = "'" 'Yes, you got it right, it's...

CirquedeSQLeil (4/21/2010)

---

jcrawf02 (4/21/2010)

---

Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛

And now for something completely different...

Any advice on ridding my lawn of...

jcrawf02 (4/21/2010)

---

Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛

And now for something completely different...

Any advice on ridding my lawn of the...