([font="Arial Black"]Be careful folks... [/font]if you're easily offended, there are some places on the referenced sight below that will knock your socks off.)

Heh... Not sure how I got to the...

I guess I do it backwards, then. I write out one "iteration" in regular code and test the willicurs out of it. Then, I just do a search...

Oh, it absolutely is... one that is condemned by many "experts" who have yet to get it to break. ...

And, yet, we go on without the ISO/IEC 9075 SQL2008 standard in SQL Server 2008 just as we have done without various other standards for zealots, lunatics, and database politicians...

Yeah... you're right, of course... I didn't think about those particular things... I think it's because I dream of a database where developers won't be dropping indexes out from under...

jacroberts (1/3/2009)

---

BWAA-HAAA!!! Well, at least I know someone read the code. Yes sir, I...

RBarryYoung (1/3/2009)

---

You know, I'm not sure how much point there is to this particular exercise. 90% of the time is in the intiial scanning of the WebLogEvents table and...

RBarryYoung (1/3/2009)

---

Jeff Moden (1/3/2009)

---

Just a hint about speed... I've found that SQL Server and I both have a couple of things in common... we're both lazy and neither of us...

jacroberts (1/3/2009)

---

Jeff, That's a neat way of doing it. I hadn't read up on setting working variables through update statement process so that's new to me.

I will test both your...

Barry, coming from the likes of you, that's a totally awesome compliment. Thanks, ol' friend.

Just a hint about speed... I've found that SQL Server and I both have a...

tfifield (1/3/2009)

---

Jeff,

As I pointed out the sequence table is ugly and only works for a single insert. It should only be done when there are interactive inserts done by...

RBarryYoung (1/3/2009)

---

Thanks. Yeah, error-handling is a bit of a pain, but I have done it with this approach and on much more difficult ones than this (changing databases, which...

Just a followup folks... I tried the original cursor/While loop based function on my box... now, keep in mind that it doesn't produce the required output... it just creates a...

Phil Factor (1/3/2009)

---

Jeff,

My solution was almost identical, except that I did an explicit create for the temporary table. (I'm showing my age here; It used to lock system tables for...

OK... here we go. First, I'm gonna recommend that you add the following index to the WebLogEvents table... it will NOT interfere with inserts or deletes, will not need...