Ah, that will be why your recent posts have been given a full designer makeover then!

Gabriel P (3/13/2010)

---

Chris -

That's very nice work. I ran it on the code I used in the article, and modified all the decimal variables/fields to (8,2) and it provided just...

I wonder...

Make some data:

DROP TABLE #Temp

SELECT TOP 1000000

RowID = IDENTITY(int, 1, 1),

Avg20day = CAST(NULL AS DECIMAL(16,6))

INTO #Temp

FROM master.dbo.syscolumns a, master.dbo.syscolumns b

CREATE UNIQUE CLUSTERED INDEX RowID ON #Temp (RowID)

--...

CirquedeSQLeil (3/11/2010)

---

ChrisM@home (3/11/2010)

---

To paraphrase Nicole Kidman..."I get to sleep with a...

To paraphrase Nicole Kidman..."I get to sleep with a hippo"

20,022 posts 5 minutes ago. Here's a BIG friggin' beer to the old git who taught me most of what...

GSquared (3/11/2010)

---

That's me with 2 months...

Timothy

If your version really is SS2K8 then you should have a quick peek in BOL at text datatype to get a good idea of why you should change your column...

Blimey! I was going to suggest it was because in query 1, the workorder table isn't in the FROM list, so the WHERE clause wouldn't work, leading to an unrestricted...

GilaMonster (3/8/2010)

---

Look at the times of the posts. I was editing...

You have an echo, Gail. I nearly wasted a mouthful of beer reading the OP's reply to your post.

No problem...

;WITH OrderedSource AS (

SELECT ExecSeq = ROW_NUMBER() OVER (ORDER BY ID, EntryDate),

RowOfID = ROW_NUMBER() OVER (PARTITION BY ID ORDER BY ID, EntryDate),

RowsPerID = COUNT(ID) OVER(PARTITION BY ID),...

Jeff Moden (3/7/2010)

---

Heh... probably not enough coffee on my part, yet, but I'm missing it, Chris. How can you use the code you posted to produce the ID_Line_No column...

lmu92 (3/7/2010)

---

ChrisM@home (3/7/2010)

---

...

You've posted a third method for resolving this job, late on a saturday night after a few beers because you had a spare 5 minutes. Puts it...

Lowell (1/27/2010)

---

to do the equivilent of row-number() in 2000, I've always had to create a temp table with an extra column, insert the data into the table, then run an...