Author |
Topic  |
Kristen
Test
United Kingdom
22859 Posts |
Posted - 10/07/2005 : 09:52:56
|
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
|
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 ..."  |
 |
|
Kristen
Test
United Kingdom
22859 Posts |
Posted - 10/07/2005 : 09:58:57
|
Yeah, watching rebuilds and data imports run :-( |
 |
|
Seventhnight
Flowing Fount of Yak Knowledge
USA
2878 Posts |
Posted - 10/07/2005 : 09:59:36
|
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 ..."  |
 |
|
madhivanan
Premature Yak Congratulator
India
22864 Posts |
Posted - 10/07/2005 : 10:01:55
|
Good Statistician 
>>Maddy ?? 1000
Test Failed(because of Title)? 
Madhivanan
Failing to plan is Planning to fail |
 |
|
TG
Flowing Fount of Yak Knowledge
USA
6065 Posts |
Posted - 10/07/2005 : 10:30:40
|
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 |
 |
|
madhivanan
Premature Yak Congratulator
India
22864 Posts |
Posted - 10/07/2005 : 10:35:16
|
>>how did you figure out the dates for individual 1k, 2k, etc?
Thru congratulatory topics 
Madhivanan
Failing to plan is Planning to fail |
 |
|
Kristen
Test
United Kingdom
22859 Posts |
Posted - 10/07/2005 : 10:35:37
|
"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 |
 |
|
graz
Chief SQLTeam Crack Dealer
USA
4149 Posts |
Posted - 10/07/2005 : 10:57:31
|
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. |
 |
|
ditch
Flowing Fount of Yak Knowledge
South Africa
1466 Posts |
Posted - 10/07/2005 : 10:58:53
|
Send us the connection string for that please Kristen 
Duane.  |
 |
|
Kristen
Test
United Kingdom
22859 Posts |
Posted - 10/07/2005 : 11:22:32
|
graz would kill me ...  |
 |
|
AjarnMark
SQL Slashing Gunting Master
USA
3246 Posts |
|
Kristen
Test
United Kingdom
22859 Posts |
Posted - 10/08/2005 : 05:30:59
|
"Ilya hits 1000"
Ilya who? 
Kristen |
Edited by - Kristen on 10/09/2005 13:32:19 |
 |
|
rockmoose
SQL Natt Alfen
Sweden
3279 Posts |
Posted - 10/09/2005 : 13:25:16
|
Humble man, You did not include yourself on the list. _______________________________________________ (ok, it's in the other thread, but for completeness...)
rockmoose |
 |
|
madhivanan
Premature Yak Congratulator
India
22864 Posts |
Posted - 10/10/2005 : 01:14:40
|
>>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 |
 |
|
AjarnMark
SQL Slashing Gunting Master
USA
3246 Posts |
Posted - 10/10/2005 : 15:09:20
|
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 |
 |
|
JimL
SQL Slinging Yak Ranger
USA
1537 Posts |
Posted - 10/11/2005 : 08:51:03
|
Sure Forgotten again 
LOL 
Jim Users <> Logic |
 |
|
madhivanan
Premature Yak Congratulator
India
22864 Posts |
Posted - 10/12/2005 : 02:58:46
|
Thanks Ajarn 
Madhivanan
Failing to plan is Planning to fail |
 |
|
X002548
Not Just a Number
15586 Posts |
|
madhivanan
Premature Yak Congratulator
India
22864 Posts |
|
Kristen
Test
United Kingdom
22859 Posts |
Posted - 11/09/2005 : 02:03:43
|
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 |
 |
|
Topic  |
|
|
|