for an ad-free Fetcheveryone experience!

Killing Threads - whose best?

12 watchers

1
2
3
4
Next
Last

BigChiefRunningBore Jul 2007 1:27pm, 5 Jul 2007 85 posts	0 BigChiefRunningBore I wonder if Mr Fetch can tell us who holds the record for stopping threads dead in thier tracks?<br><br>Being on the boring side, I seem quite good at it but Mudmanic says he's better. Can Mr Fetch help? <br><br>Feel free to say something unhelpful.
runnerbean Jul 2007 1:30pm, 5 Jul 2007 8,215 posts	0 runnerbean ok, get lost
runnerbean Jul 2007 1:31pm, 5 Jul 2007 8,216 posts	0 runnerbean ho did i do? did i stop it?
BigChiefRunningBore Jul 2007 1:33pm, 5 Jul 2007 87 posts	0 BigChiefRunningBore Was short of hoping no one would post. But then will feel a bit billy-no-mates. Ha could kill my own thread. Cheers
Blister Jul 2007 1:46pm, 5 Jul 2007 2,737 posts	0 Blister ME! Fetch could probably tell you that number by running a query on all threads that haven't had any posts for say a week and find out who the last person to post was, then see which person is most often the last person to post on threads that are say a week old. Say somethine like: SELECT UserID, COUNT(UserID) AS UserCount FROM tblPost WHERE tblPost.PostDate <= (DATE - 7) GROUP BY tblPost.UserID ORDER BY UserCount DESC; (Sorry my SQL needs brushing up on...but something along those lines) I bet this will kill the thread
Blister Jul 2007 1:47pm, 5 Jul 2007 2,738 posts	0 Blister hmm, half of that was chopped of because I used the less than sign!
RunningBob Jul 2007 1:48pm, 5 Jul 2007 402 posts	0 RunningBob Well that's killed this one Blister
BigChiefRunningBore Jul 2007 1:51pm, 5 Jul 2007 88 posts	0 BigChiefRunningBore wot he on about? Chief stratches head were computers make it sore
BigChiefRunningBore Jul 2007 1:52pm, 5 Jul 2007 89 posts	0 BigChiefRunningBore good try A65 but beat you to it
SparkyMark Jul 2007 1:53pm, 5 Jul 2007 5,775 posts	0 SparkyMark SQL freak