SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Kristens List
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 6

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/07/2005 :  09:52:56  Show Profile  Reply with Quote
Congratulations Madhi! 11000 posts on 20-Sep-2007

See: Queries using this raw data

declare @posts table
(
poster varchar(30),
date datetime,
posts int
)
insert into @posts
-- afrika
SELECT 'afrika', '20041119', 0 UNION ALL
SELECT 'afrika', '20060215', 1000 UNION ALL

-- Arnold Fribble
SELECT 'Arnold Fribble', '20011111', 0 UNION ALL
SELECT 'Arnold Fribble', '20030714', 1000 UNION ALL

-- AjarnMark
SELECT 'AjarnMark', '20010711', 0 UNION ALL
SELECT 'AjarnMark', '20020109', 1000 UNION ALL
SELECT 'AjarnMark', '20040106', 2000 UNION ALL
SELECT 'AjarnMark', '20051010', 3000 UNION ALL

-- AndrewMurphy
SELECT 'AndrewMurphy', '20001128', 0 UNION ALL
SELECT 'AndrewMurphy', '20040702', 1000 UNION ALL
SELECT 'AndrewMurphy', '20070115', 2000 UNION ALL

-- bLindman
SELECT 'bLindman', '20051014', 0 UNION ALL
SELECT 'bLindman', '20070412', 1000 UNION ALL

-- Brett
SELECT 'Brett', '20030102', 0 UNION ALL
SELECT 'Brett', '20030529', 1000 UNION ALL
SELECT 'Brett', '20030728', 2000 UNION ALL
SELECT 'Brett', '20031112', 3000 UNION ALL
SELECT 'Brett', '20040324', 4000 UNION ALL
SELECT 'Brett', '20040716', 5000 UNION ALL
SELECT 'Brett', '20041213', 6000 UNION ALL
-- ???
SELECT 'Brett', '20051108', 8000 UNION ALL
SELECT 'Brett', '20060927', 9000 UNION ALL
SELECT 'Brett', '20070413', 9999 UNION ALL

-- Byrmol
SELECT 'Byrmol', '20010925', 0 UNION ALL
SELECT 'Byrmol', '20040714', 1000 UNION ALL

-- chadmat
SELECT 'chadmat', '20011217', 0 UNION ALL
SELECT 'chadmat', '20030730', 1000 UNION ALL

-- chiragkhabaria
SELECT 'chiragkhabaria', '20050426', 0 UNION ALL
SELECT 'chiragkhabaria', '20060820', 1000 UNION ALL

-- Derrick
SELECT 'Derrick', '20020618', 0 UNION ALL
-- ???
SELECT 'Derrick', '20050407', 3000 UNION ALL
SELECT 'Derrick', '20060118', 4000 UNION ALL

-- Dinakar
SELECT 'Dinakar', '20070326', 0 UNION ALL
SELECT 'Dinakar', '20070525', 1000 UNION ALL

-- Ditch
SELECT 'Ditch', '20040202', 0 UNION ALL
SELECT 'Ditch', '20051007', 1000 UNION ALL

-- Elwoos
SELECT 'Elwoos', '20030204', 0 UNION ALL
SELECT 'Elwoos', '20051130', 999 UNION ALL

-- ehorn
SELECT 'ehorn', '20020906', 0 UNION ALL
SELECT 'ehorn', '20040718', 1000 UNION ALL

-- eyechart
SELECT 'eyechart', '20030530', 0 UNION ALL
SELECT 'eyechart', '20050321', 1000 UNION ALL
SELECT 'eyechart', '20060223', 2000 UNION ALL
SELECT 'eyechart', '20070225', 3000 UNION ALL

-- Graz
SELECT 'Graz', '20000624', 0 UNION ALL
SELECT 'Graz', '20020611', 1000 UNION ALL
-- ???
SELECT 'Graz', '20051118', 3000 UNION ALL

-- Harsh
SELECT 'Harsh', '20060627', 0 UNION ALL
SELECT 'Harsh', '20061119', 1000 UNION ALL
SELECT 'Harsh', '20070213', 2000 UNION ALL
SELECT 'Harsh', '20070510', 3000 UNION ALL

-- izaltsman
SELECT 'izaltsman', '20010306', 0 UNION ALL
SELECT 'izaltsman', '20020624', 1000 UNION ALL

-- Jeff
SELECT 'Jeff', '20021107', 0 UNION ALL
SELECT 'Jeff', '20030511', 1000 UNION ALL
SELECT 'Jeff', '20040119', 2000 UNION ALL
SELECT 'Jeff', '20041110', 3000 UNION ALL
SELECT 'Jeff', '20050516', 4000 UNION ALL
SELECT 'Jeff', '20060719', 5000 UNION ALL
SELECT 'Jeff', '20070510', 6000 UNION ALL

-- jezemine
SELECT 'jezemine', '20060920', 0 UNION ALL
SELECT 'jezemine', '20070528', 1000 UNION ALL

-- Jen
SELECT 'Jen', '20040723', 0 UNION ALL
SELECT 'Jen', '20041203', 1000 UNION ALL
SELECT 'Jen', '20051005', 2000 UNION ALL
SELECT 'Jen', '20060525', 3000 UNION ALL

-- jhermiz
SELECT 'jhermiz', '20030102', 0 UNION ALL
SELECT 'jhermiz', '20040921', 1000 UNION ALL
SELECT 'jhermiz', '20050428', 2000 UNION ALL
SELECT 'jhermiz', '20060322', 3000 UNION ALL
SELECT 'jhermiz', '20060330', 3088 UNION ALL

-- JimL
SELECT 'JimL', '20030221', 0 UNION ALL
SELECT 'JimL', '20050518', 1000 UNION ALL

-- JustinBigelow
SELECT 'JustinBigelow', '20010418', 0 UNION ALL
SELECT 'JustinBigelow', '20030603', 1000 UNION ALL

-- khtan
SELECT 'khtan', '20051030', 0 UNION ALL
SELECT 'khtan', '20060220', 1000 UNION ALL
SELECT 'khtan', '20060508', 2000 UNION ALL
SELECT 'khtan', '20060731', 3000 UNION ALL
SELECT 'khtan', '20061101', 4000 UNION ALL
SELECT 'khtan', '20070228', 5000 UNION ALL
SELECT 'khtan', '20070424', 6000 UNION ALL
SELECT 'khtan', '20070712', 7000 UNION ALL

-- Madhi
SELECT 'Madhi', '20041120', 0 UNION ALL
SELECT 'Madhi', '20050719', 1000 UNION ALL
SELECT 'Madhi', '20050910', 2000 UNION ALL
SELECT 'Madhi', '20051026', 3000 UNION ALL
SELECT 'Madhi', '20051214', 4000 UNION ALL
SELECT 'Madhi', '20060210', 5000 UNION ALL
SELECT 'Madhi', '20060417', 6000 UNION ALL
SELECT 'Madhi', '20060621', 7000 UNION ALL
SELECT 'Madhi', '20061002', 8000 UNION ALL
SELECT 'Madhi', '20061220', 9000 UNION ALL
SELECT 'Madhi', '20070613', 10000 UNION ALL
SELECT 'Madhi', '20070920', 11000 UNION ALL

-- Merkin
SELECT 'Merkin', '20000802', 0 UNION ALL
SELECT 'Merkin', '20011012', 1000 UNION ALL
SELECT 'Merkin', '20020707', 2000 UNION ALL
-- ???
SELECT 'Merkin', '20050208', 4000 UNION ALL

-- MichaelP
SELECT 'MichaelP', '20011213', 0 UNION ALL
SELECT 'MichaelP', '20031215', 1000 UNION ALL
SELECT 'MichaelP', '20050603', 2000 UNION ALL

-- mohdowais
SELECT 'mohdowais', '20021117', 0 UNION ALL
SELECT 'mohdowais', '20040317', 1000 UNION ALL

-- mr_mist
SELECT 'mr_mist', '20020730', 0 UNION ALL
SELECT 'mr_mist', '20040831', 1000 UNION ALL

-- MVJ
SELECT 'MVJ', '20050107', 0 UNION ALL
SELECT 'MVJ', '20051129', 1000 UNION ALL
SELECT 'MVJ', '20060619', 2000 UNION ALL
SELECT 'MVJ', '20061018', 3000 UNION ALL
SELECT 'MVJ', '20070608', 4000 UNION ALL

-- mfemenel
SELECT 'mfemenel', '20010215', 0 UNION ALL
SELECT 'mfemenel', '20061113', 1000 UNION ALL

-- Nigel
SELECT 'Nigel', '20010219', 0 UNION ALL
--??
SELECT 'Nigel', '20011112', 2000 UNION ALL
--???
SELECT 'Nigel', '20030922', 5000 UNION ALL
SELECT 'Nigel', '20040511', 6000 UNION ALL
SELECT 'Nigel', '20041109', 7000 UNION ALL
SELECT 'Nigel', '20050215', 8000 UNION ALL
SELECT 'Nigel', '20060328', 9000 UNION ALL
SELECT 'Nigel', '20060725', 10000 UNION ALL
SELECT 'Nigel', '20070327', 11000 UNION ALL

-- Page47
SELECT 'Page47', '20020409', 0 UNION ALL
-- ??
SELECT 'Page47', '20030414', 2000 UNION ALL

-- Peso
SELECT 'Peso', '20060512', 0 UNION ALL
SELECT 'Peso', '20060818', 1000 UNION ALL
SELECT 'Peso', '20060919', 2000 UNION ALL
-- 20062309 Title
SELECT 'Peso', '20061030', 3000 UNION ALL
SELECT 'Peso', '20061127', 4000 UNION ALL
SELECT 'Peso', '20061222', 5000 UNION ALL
SELECT 'Peso', '20070131', 6000 UNION ALL
SELECT 'Peso', '20070314', 7000 UNION ALL
SELECT 'Peso', '20070412', 8000 UNION ALL
SELECT 'Peso', '20070713', 9000 UNION ALL
SELECT 'Peso', '20070823', 10000 UNION ALL
SELECT 'Peso', '20070918', 11000 UNION ALL

-- RickD
SELECT 'RickD', '20010606', 0 UNION ALL
SELECT 'RickD', '20060210', 1000 UNION ALL

-- rmiao
SELECT 'rmiao', '20070409', 0 UNION ALL
SELECT 'rmiao', '20070621', 1000 UNION ALL
SELECT 'rmiao', '20070729', 2000 UNION ALL

-- RobV
SELECT 'RobV', '20001115', 0 UNION ALL
SELECT 'RobV', '20010514', 1000 UNION ALL
SELECT 'RobV', '20011025', 2000 UNION ALL
-- ??
SELECT 'RobV', '20020522', 4000 UNION ALL
-- ???
SELECT 'RobV', '20030102', 6000 UNION ALL
SELECT 'RobV', '20030714', 7000 UNION ALL
SELECT 'RobV', '20040305', 8000 UNION ALL
SELECT 'RobV', '20050113', 9000 UNION ALL
SELECT 'RobV', '20050614', 10000 UNION ALL -- and here
SELECT 'RobV', '20061011', 11000 UNION ALL -- and here

-- Rocky
SELECT 'Rocky', '20040704', 0 UNION ALL
-- ??
SELECT 'Rocky', '20050811', 2000 UNION ALL
SELECT 'Rocky', '20061116', 3000 UNION ALL

-- rrb
SELECT 'rrb', '20011018', 0 UNION ALL
SELECT 'rrb', '20040210', 1000 UNION ALL

-- Sam
SELECT 'Sam', '20020524', 0 UNION ALL
SELECT 'Sam', '20030808', 1000 UNION ALL
SELECT 'Sam', '20040720', 2000 UNION ALL
SELECT 'Sam', '20051207', 3000 UNION ALL

-- Seventhnight
SELECT 'Seventhnight', '20040524', 0 UNION ALL
SELECT 'Seventhnight', '20041016', 1000 UNION ALL
SELECT 'Seventhnight', '20050823', 2000 UNION ALL

-- snSQL
SELECT 'snSQL', '20060209', 0 UNION ALL
SELECT 'snSQL', '20061229', 1000 UNION ALL

-- Srinika
SELECT 'Srinika', '20040524', 0 UNION ALL
SELECT 'Srinika', '20060713', 1000 UNION ALL

-- Spirit1
SELECT 'Spirit1', '20040506', 0 UNION ALL
SELECT 'Spirit1', '20040924', 1000 UNION ALL
SELECT 'Spirit1', '20050119', 2000 UNION ALL
SELECT 'Spirit1', '20050321', 3000 UNION ALL
SELECT 'Spirit1', '20050910', 4000 UNION ALL
SELECT 'Spirit1', '20060330', 5000 UNION ALL
SELECT 'Spirit1', '20061031', 6000 UNION ALL
SELECT 'Spirit1', '20070503', 7000 UNION ALL
SELECT 'Spirit1', '20070803', 8000 UNION ALL

-- Stoad
SELECT 'Stoad', '20030621', 0 UNION ALL
SELECT 'Stoad', '20040106', 1000 UNION ALL

-- TG
SELECT 'TG', '20041229', 0 UNION ALL
SELECT 'TG', '20050822', 1000 UNION ALL
SELECT 'TG', '20060731', 2000 UNION ALL

-- Tara

SELECT 'Tara', '20021009', 0 UNION ALL
SELECT 'Tara', '20030501', 1000 UNION ALL
SELECT 'Tara', '20030805', 2000 UNION ALL
SELECT 'Tara', '20031015', 3000 UNION ALL
SELECT 'Tara', '20040106', 4000 UNION ALL
SELECT 'Tara', '20040311', 5000 UNION ALL
-- ???
SELECT 'Tara', '20041130', 9000 UNION ALL
SELECT 'Tara', '20050312', 10000 UNION ALL
SELECT 'Tara', '20050721', 11000 UNION ALL
SELECT 'Tara', '20051201', 12000 UNION ALL
SELECT 'Tara', '20060419', 13000 UNION ALL
SELECT 'Tara', '20060817', 14000 UNION ALL
SELECT 'Tara', '20070105', 15000 UNION ALL
SELECT 'Tara', '20070420', 16000 UNION ALL
SELECT 'Tara', '20070915', 17000 UNION ALL

-- timmy
SELECT 'timmy', '20010910', 0 UNION ALL
SELECT 'timmy', '20060828', 1000 UNION ALL

-- ValterBorges
SELECT 'ValterBorges', '20010327', 0 UNION ALL
SELECT 'ValterBorges', '20030429', 1000 UNION ALL

-- Wanderer
SELECT 'Wanderer', '20020121', 0 UNION ALL
SELECT 'Wanderer', '20060814', 1000 UNION ALL

-- Self
SELECT 'Self', '20040412', 0 UNION ALL
SELECT 'Self', '20040723', 1000 UNION ALL
-- 2000 ???
SELECT 'Self', '20050317', 3000 UNION ALL
SELECT 'Self', '20050805', 4000 UNION ALL
SELECT 'Self', '20051006', 5000 UNION ALL
SELECT 'Self', '20051208', 6000 UNION ALL
SELECT 'Self', '20060223', 7000 UNION ALL
SELECT 'Self', '20060518', 8000 UNION ALL
SELECT 'Self', '20060916', 9000 UNION ALL
SELECT 'Self', '20061121', 10000 UNION ALL
SELECT 'Self', '20070211', 11000 UNION ALL
SELECT 'Self', '20070517', 12000 UNION ALL
SELECT 'Self', '20070829', 13000 -- UNION ALL

Edited by - Kristen on 09/21/2007 03:59:52

Seventhnight
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 10/07/2005 :  09:58:02  Show Profile  Visit Seventhnight's Homepage  Reply with Quote
time to kill ???

Corey

Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/07/2005 :  09:58:57  Show Profile  Reply with Quote
Yeah, watching rebuilds and data imports run :-(
Go to Top of Page

Seventhnight
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 10/07/2005 :  09:59:36  Show Profile  Visit Seventhnight's Homepage  Reply with Quote
you can do my work for me... I got homework to work on

Corey

Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22713 Posts

Posted - 10/07/2005 :  10:01:55  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Good Statistician

>>Maddy
?? 1000

Test Failed(because of Title)?


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
5946 Posts

Posted - 10/07/2005 :  10:30:40  Show Profile  Reply with Quote
Speaking of milestones, when will sqlteam member list get to 1K pages? There should be a lot of emoti-beers when that happens :)

ok, i give up...how did you figure out the dates for individual 1k, 2k, etc?

Be One with the Optimizer
TG
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22713 Posts

Posted - 10/07/2005 :  10:35:16  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
>>how did you figure out the dates for individual 1k, 2k, etc?

Thru congratulatory topics

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/07/2005 :  10:35:37  Show Profile  Reply with Quote
"how did you figure out the dates for individual 1k, 2k,"

SELECT PostingDate, TopicID
FROM FORUMS.[The Yak Corral]
WHERE MessageText LIKE '%Congratulations%'
GROUP BY MemberName

Kristen
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4137 Posts

Posted - 10/07/2005 :  10:57:31  Show Profile  Visit graz's Homepage  Reply with Quote
quote:
Originally posted by madhivanan

>>how did you figure out the dates for individual 1k, 2k, etc?

Thru congratulatory topics

Madhivanan

Failing to plan is Planning to fail



Is that really what you did? I was sitting here trying to figure out how you'd figured it out. That's creative!

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

ditch
Flowing Fount of Yak Knowledge

South Africa
1466 Posts

Posted - 10/07/2005 :  10:58:53  Show Profile  Visit ditch's Homepage  Reply with Quote
Send us the connection string for that please Kristen

Duane.
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/07/2005 :  11:22:32  Show Profile  Reply with Quote
graz would kill me ...
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 10/07/2005 :  17:40:03  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
Hey, Kristen, your youth is showing. You searched the Yak Corral. But before the Yak Corral was created, things like this appeared in the Site Related Discussions.

See
Rob hits 1000
Damian hits 1000
Ilya hits 1000
Mark hits 1000
And finally... Can you believe we used to celebrate 50 and 100 like we do 1000 now?

---------------------------
EmeraldCityDomains.com
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/08/2005 :  05:30:59  Show Profile  Reply with Quote
"Ilya hits 1000"

Ilya who?

Kristen

Edited by - Kristen on 10/09/2005 13:32:19
Go to Top of Page

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 10/09/2005 :  13:25:16  Show Profile  Reply with Quote
Humble man, You did not include yourself on the list.
_______________________________________________
(ok, it's in the other thread, but for completeness...)

rockmoose
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22713 Posts

Posted - 10/10/2005 :  01:14:40  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
>>Is that really what you did? I was sitting here trying to figure out how you'd figured it out. That's creative!

I hope Kristen did like that
Otherwise noway to find this

I am also interested to know who is Ilya

Madhivanan

Failing to plan is Planning to fail

Edited by - madhivanan on 10/10/2005 01:15:58
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 10/10/2005 :  15:09:20  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
Ilya Zaltsman a.k.a. izaltsman is a sharp chap from Quincy, Massachussettes. He hasn't posted here since December, 2004. I hope nothing bad happened to him. He had great answers to a lot of questions.

Maybe he gave up coming here until he got his custom title.

---------------------------
EmeraldCityDomains.com
Go to Top of Page

JimL
SQL Slinging Yak Ranger

USA
1534 Posts

Posted - 10/11/2005 :  08:51:03  Show Profile  Visit JimL's Homepage  Reply with Quote
Sure Forgotten again



LOL

Jim
Users <> Logic
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22713 Posts

Posted - 10/12/2005 :  02:58:46  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Thanks Ajarn

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/27/2005 :  12:31:48  Show Profile  Reply with Quote
Hopefully I'll get you a 7k one soon, but I think Tara may hit 12 before that....



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22713 Posts

Posted - 11/09/2005 :  01:12:12  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Kris, can you update these?

My 1K - http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52590
Rob's actual 10k - http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51098


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 11/09/2005 :  02:03:43  Show Profile  Reply with Quote
Maddy you've got to much free time!

I'm going to ban people from having >9999 posts as its mucking up my column alignment, and as we all know that's a presentation issue and I can't be ar$ed to fix it!

Kristen
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.58 seconds. Powered By: Snitz Forums 2000