The "last one to post on this thread wins" Thread

Pfff.. I dont' think so...

Code:

---

DECLARE @OrigPostID int
DECLARE @ME int

SET @ME = (SELECT PosterID FROM Posters WHERE Name = 'KrisSimonis')
SET @OrigPostID = (SELECT TOP 1 PostID FROM Posts WHERE TopicName = 'The "last one to post on this thread wins" Thread' ORDER BY PostDate)

UPDATE Posts
SET PosterID = @ME
    , Locked = TRUE
WHERE PostID = (SELECT TOP 1 PostID
                FROM Posts
                WHERE OrigPostID = @OrigPostID
                ORDER BY PostDate DESC)

---

Now who's the last poster Eh?

Quote:

---

Originally Posted by KrisSimonis

Pfff.. I dont' think so...

Code:

---

DECLARE @OrigPostID int
DECLARE @ME int

SET @ME = (SELECT PosterID FROM Posters WHERE Name = 'KrisSimonis')
SET @OrigPostID = (SELECT TOP 1 PostID FROM Posts WHERE TopicName = 'The "last one to post on this thread wins" Thread' ORDER BY PostDate)

UPDATE Posts
SET PosterID = @ME
    , Locked = TRUE
WHERE PostID = (SELECT TOP 1 PostID
                FROM Posts
                WHERE OrigPostID = @OrigPostID
                ORDER BY PostDate DESC)

---

Now who's the last poster Eh?

---

sigh...

What?

Boring Sydney, Boring.....

I admit even I'm getting bored of this thread :(

You got up at that time to post that? Not late enough

What do you mean?

OMGH !!! :eek: this thread is still running ?

Yes, yes it is :)

Oh my...so what's the verdict so far? I am over a 1000 posts late!

For those who came in late...I am the 'unofficial' winner of the 3000th post :cool:

Interesting thread... I like it :D

lemme just slip a post in here..

Well I hate the guy who made this thread because I just can't turn away from posting! :)

You may be the only one alive when it finally ends, though.