| Author |
 Topic  |
|
Kristen
Test
United Kingdom
22431 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
22431 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
22791 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
6062 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
22791 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
22431 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
4141 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
22431 Posts |
Posted - 10/07/2005 : 11:22:32
|
| graz would kill me ... |
|
|
|
AjarnMark
SQL Slashing Gunting Master
USA
3246 Posts |
|
|
Kristen
Test
United Kingdom
22431 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
22791 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
22791 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
22791 Posts |
|
|
Kristen
Test
United Kingdom
22431 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 |
|
|
|
Kristens List
