| Author |
Topic |
|
jsmith8858
Dr. Cross Join
7423 Posts |
 Posted - 2003-09-25 : 10:13:32
|
Dude, you and Tara have got to SLOW DOWN before someone gets hurt ! Halfway to Nigel ! Congratulations, have one on me. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-25 : 10:32:08
|
UPDATE Members Set PostCount = 0 WHERE PostCount > (Select PostCount From Members Where MemberName = 'Merkin')  Oh, I mean CONGRATULATIONS!!!!!   Damian |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-25 : 11:00:45
|
Thanks...Wouldn't the following do though UPDATE M SET PostCount = M2.PostCount - 1 FROM Members MINNER JOIN Members M2 ON M.MemberName = M2.Member_Name WHERE M2.MemberName = 'Merkin' AND M.PostCount > M2.PostCount zero is such a ugly number....And hey...the way it's been the last couple of weeks...slowing down is easy! Plus 3 weeks in FLA...damn my avg post count/day is now under 10 GREAT SITE! GREAT PEOPLE! (even some GRATE people...enough to spice things up)...And tons more to learn....Thanks everyone...damn, another reason to have a cocktail...Beefeater, up, dry, olive...Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2003-09-25 : 11:11:24
|
quote:
damn, another reason to have a cocktail...Beefeater, up, dry, olive...
 When will people realize you need Vodka to make a good martini?Thanks for always going above and beyond Brett!Justin"Look at it out there orbiting like it's so cool, we will rule it with an army of replicants!" |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-25 : 11:19:21
|
quote:
Originally posted by JustinBigelow
quote:
damn, another reason to have a cocktail...Beefeater, up, dry, olive...
When will people realize you need Vodka to make a good martini?
Grey Goose...shaken, not stirred...Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric!EDIT: Actually: http://members.tripod.com/~MrSuave/themartini.html |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-25 : 12:13:46
|
| Congrats Brett! I'm off to Vegas tomorrow for business (and pleasure of course) so I'll place a bet in your honor. If I win, the check will be in the mail.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-25 : 12:31:59
|
quote:
Originally posted by tduggan
Congrats Brett! I'm off to Vegas tomorrow for business (and pleasure of course) so I'll place a bet in your honor. If I win, the check will be in the mail.Tara
VIVA LAS VEGAS (Lost Wages)Haven't been since the re-did the strip...The Excalibur was the "New" casino...night and day since then...Where are you staying? How longs the drive? Used to fly in to Vegas when I has business in LA...AC can't compare...Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-25 : 13:05:05
|
| My company is sending a bunch of people there this weekend. We are staying at the Hilton Grand or at the Marriott. I'll be staying at the Hilton cuz I like that they have jacuzzis in all of the suites. The drive is about 6 hours, but they'll be flying us in. The flight is only an hour.Tara |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-09-25 : 15:11:18
|
Congrats Brett. Have a Martini on me.Sam |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-09-26 : 02:34:19
|
| WAY TO GO, BRETT!------------------------------------------------------The more you know, the more you know you don't know. |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-09-26 : 06:57:20
|
Slow down, palEasy on the triggerLet goChill outType smaller posts... Cheers Brett!!It's weekend, party time! I'll have one in your honor tonite, Brett...Cheers!! OS
Make it idiot proof and someone will make a better idiot |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-26 : 09:24:47
|
quote:
Originally posted by SamC
Congrats Brett.Have a Martini on me.Sam
How cool is that....and remember..there's no such thing as a bad martini...well I guess small would be considered bad...Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-09-26 : 09:41:06
|
Congrats Brett!PostResponse = Cast Where BrettsPosts > (JimsPosts * 10) Then Print 'Dang that Boys Fast!' EndThanks for lots of help and additional brain stimulation.  JimUsers <> Logic |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-26 : 15:37:34
|
| Well...it's friday...tehy've kicked us out of the office, unplugged the computers, and are moving us (whole 2 flights)...And what an addict...had to stop by the library to return some books, and I had to hop on...Weeeeelllllll...That Martini Sam posted is staring right at me...so I guess I'll have to do SOMETHING about it....Have a good weekend everyone...Come on Tara... 7!Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-28 : 00:24:47
|
quote:
Originally posted by X002548
Come on Tara... 7!
My game is blackjack, but it hasn't been liking me so far. Gonna give it another try tomorrow. If it doesn't work out, I will work on my tan instead.Tara |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-10-09 : 03:47:52
|
| Brett just keeps going and going. He's like the duracell bunny. Ooer.-------Moo. :) |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-10-09 : 09:20:21
|
| ...uhhhm...Energizer? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-10-15 : 15:49:08
|
| Oho!! Brett hit 2786 posts!! |
|
|
|
|
Brett hits 2500