| Author |
Topic |
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
 Posted - 2003-03-26 : 22:31:35
|
| I made it.That is all.Damian |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-26 : 23:26:20
|
Congrats Merkin. Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-03-27 : 01:13:17
|
HEY CONGRATS, MATE!!!you really whack the problems out of SQL  , way to go, aussie-dude!(Somebody please add 2500 clanging beer mugs here!)OS |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-27 : 08:24:31
|
Don't quit your day job."I am Gunnery Sergeant Merkin, your Senior Drill Instructor. From now on, you will speak only when spoken to, and the first and last words out of your filthy sewers will be "Sir!" Do you maggots understand that?Sir, yes sir!Bullshit! I can't hear you. Sound off like you got a pair!" Jay White{0} |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-03-27 : 10:37:26
|
| Thank you Damian, for all your help with the site. I never say it enough. Thank you.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-03-27 : 10:52:49
|
| WAY TO GO MERKIN !!!- Jeff |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-27 : 12:28:39
|
| 2500! Now that's a lot of posts. Congrats.Tara |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-03-27 : 12:48:29
|
WOW!!!!!!!!  |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-27 : 14:34:11
|
| This is including Weekend and Holidays of course, buit it seems to be a pretty impressive number:DECLARE @MemberSince datetime, @NumberOfPosts IntSELECT @MemberSince = '08/02/2000', @NumberOfPosts = 2500Select @NumberOfPosts/(DateDiff(dd,@MemberSince,GetDate())/1.00) As AvgPostsPerDayBrett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-27 : 14:38:20
|
BUT!!! If we do it for Rob:--MerkinDECLARE @MemberSince datetime, @NumberOfPosts IntSELECT @MemberSince = '08/02/2000', @NumberOfPosts = 2500Select @NumberOfPosts/(DateDiff(dd,@MemberSince,GetDate())/1.00) As AvgPostsPerDay-- RobVolkSELECT @MemberSince = '11/15/2000', @NumberOfPosts = 6608Select @NumberOfPosts/(DateDiff(dd,@MemberSince,GetDate())/1.00) As AvgPostsPerDaySome one is need of SERIOUS help...(when where you on a date last?) Brett8-) |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-03-27 : 14:49:39
|
| Thanks for all your help here Merkin. When are some Bondi Beach livecams coming back?======Doug G====== |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-03-27 : 14:56:54
|
Congrats Merkin!Brett: On the other hand--BrettDECLARE @MemberSince datetime, @NumberOfPosts Int SELECT @MemberSince = '01/02/2003', @NumberOfPosts = 320 Select @NumberOfPosts/(DateDiff(dd,@MemberSince,GetDate())/1.00) As AvgPostsPerDay Is quite a lot too  |
|
|
|
lee_h
Starting Member
36 Posts |
Posted - 2003-03-31 : 01:02:26
|
| Bet you thought I was going to post a reply just to get my count up! Well, I showed you, didn't I!!! |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-03-31 : 02:24:46
|
| congrats merkin and thanks for all the help.Expect the UnExpected |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-31 : 03:04:58
|
| Graz Merkin.Back to the beer now I guess.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
Weeeeeeeeeeeeeeeeeeee