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

All Forums

Site Related Forums

The Yak Corral

11k to madhivanan

Author

Topic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-20 : 13:50:56

CONGRATS MADHIVANAN!!!

well done!

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-09-20 : 17:50:21

how to find dupes in this table?

sample data:

elsasoft.org

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-20 : 18:00:37

already.... damn....

Congratulations Madhi...

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-09-20 : 18:00:50

Congrats Madhi !

well done

KH
[spoiler]Time is always against us[/spoiler]

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-09-21 : 04:34:10

[code]Select TOP 1 Poster_Name, Count(ReplyText) as Posts from tbl_Posters
where ReplyText Like '%Do it in Front-End%'
Group by Poster_Name
Order by 2 Desc[/code]

[code]Poster_Name Posts
--------------------------------- --------
Madhivanan 11014[/code]