So much for the first rule of DBA's... ethics.

But, I liked the parenthesis... 😛

"IT is working..."

What is working?

Be very careful... the recursive CTE method will be slower than even a poorly formed cursor.

Looks fine to me, Andrew. Sorry for the panic, but I went into a panic when I saw that the group numbers weren't unique across items when I was...

Mark (2/12/2009)

---

DECLARE @PerDay INT

SET @PerDay = 2

SELECT

ORDER_DT = DATEADD(d,t1.N-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE())-1,0)),

ORDER_QTY = ABS(CHECKSUM(NEWID()))%1000+1, --<== Stole from Jeff

...

Ok... now I trust it... just gotta remember to NOT let the fact that GroupNums aren't unique across items but the combination of Item and GroupNum works as expected when...

Yeah... that fixes it... or at least for this particular problem...

;WITH

cteRowNumItem AS

(

SELECT SampleDate,

Item,

...

Jeff Moden (2/14/2009)

---

RBarryYoung (1/31/2009)

---

Heh. You know Jeff, I think that this might change that article that you're writing, just a little bit. I bet you don't mind too...

Thanks, Brian. My short term memory is pretty well shot... correct me if I'm wrong, please... you weren't one of the...

RBarryYoung (1/31/2009)

---

Heh. You know Jeff, I think that this might change that article that you're writing, just a little bit. I bet you don't mind too much though....

😛

It's obvious that you took the path to the dark side or you would have simply said that you used the Identity column. World of hurt awaits you with...

No problem... looking back at it, I can see how someone might mistake it. Thanks for the feedback, Andrew.

Nice eye, Milla. Guess I need more coffee.