SQL Server Forums - Kristens List

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums

Profile | 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

Reply to Topic

Printer Friendly

Author

Topic

Page: of 6

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

Posted - 10/07/2005 : 17:40:03

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

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

Posted - 10/27/2005 : 12:31:48

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

madhivanan
Premature Yak Congratulator

India
22864 Posts

Posted - 11/09/2005 : 01:12:12

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

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

Page: of 6

Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.12 seconds.