TOP 1 - SQL Server Forums

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

TOP 1

Author

Topic

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-20 : 23:54:32

[code]
SELECT TOP 1 member_name
FROM members
ORDER BY posts DESC

/*
member_name
------------------------------
Peso

(1 row(s) affected)
*/
[/code]

Congratulation Peter

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

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-21 : 03:44:05

Where did you hide the ORDER BY NEWID()

Thank you.
And if I may say so, "Not bad for an entry level dba".

E 12°55'05.63"
N 56°04'39.26"

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-06-21 : 06:55:19

[code]SELECT TOP 1 member_name
FROM members
WHERE POST='Lousy'
ORDER BY posts ASC

/*
member_name
------------------------------
WaterDuck

(1 row(s) affected)
*/
[/code]

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-21 : 11:53:29

Congratulations Peter!
Herzlichen Glückwunsch!
grattis!

No, you're never too old to Yak'n'Roll if you're too young to die.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-22 : 02:29:15

Congratulations Peso. Keep it up

Madhivanan

Failing to plan is Planning to fail

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2009-06-22 : 08:30:14

Peter,

Congratulations! That is fantastic! Thanks for all the help you've given people.

-Bill

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-22 : 08:42:09

Vielen Dank webfred!
Ich sehe, dass Sie Ihr Deutsch ist mycklet besser ist als meine eigenen. In meiner Verteidigung, ich muß darauf hinweisen, daß es 22 Jahre seit ich Deutsch in der Schule lesen.

Thank you Madhi, and thank you Bill!
We'll have to talk more later about Pass Europe 2010 :-)

E 12°55'05.63"
N 56°04'39.26"

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-06-22 : 09:39:30

Awwww, our Entry Level DBA™ is growing up!

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-22 : 09:43:21

It depends on what next level is.
What comes after Entry Level?

E 12°55'05.63"
N 56°04'39.26"

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2009-06-22 : 10:11:52

maybe "Enterprise Level"

Are you never going to let this "Entry Level DBA" thing lie. I think mr. Fang has left the building......

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-06-22 : 10:21:37

Congratulations Peter!

You're the Enterprise Level Saint!

CODO ERGO SUM

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2009-06-22 : 10:27:17

Oh -- completely forgot to say:
Congratulations
Also, thanks for all the advice and general banter.

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2009-06-22 : 10:31:06

quote:

Originally posted by waterduck

SELECT	TOP 1 member_name
FROM	members
WHERE  POST='Lousy'
ORDER BY posts ASC

/*
member_name                    
------------------------------ 
WaterDuck

(1 row(s) affected)
*/

Was that a deliberate mistake waterduck (to illustrate how lousy)? or are you saying that you are the LEAST Lousy person here......


SELECT TOP 1 *
FROM (
      SELECT 'Transact Charlie' AS [Member], 45 AS [Lousy-Posts]
UNION SELECT 'WaterDuck'        AS [Member], 5 AS [Lousy-Posts]
	)
	lousy
ORDER BY
	[Lousy-Posts] ASC

Results


Member           Lousy-Posts
---------------- -----------
WaterDuck        5

(1 row(s) affected)

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-06-22 : 10:43:23

Peter congratulations.. you have amazing patience.. keep it up..

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

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2009-06-22 : 11:39:48

Peter
zer goot mein heir

Sorry I don't know any swedish, German was as close as I cound get.

Congrats

Jim
Users <> Logic

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-22 : 11:41:32

Charlie, thank you! You have interesting questions and it's fun to solve them.

Michael and Dinakar, thank you both for your support!
I enjoy your time solutions Michael, and I read more and more of hour posts Dinakar about administering SQL Server.

E 12°55'05.63"
N 56°04'39.26"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-06-24 : 18:41:16

Congrats Peter! I'm surprised that it took so long to pass me as I haven't been posting much lately. Now you've got to fight with visakh for that top spot!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-24 : 18:53:35

Thank you Tara, and that will not be much of a fight.
Visakh can have the spot, it's nothing I desire.
I am more looking forward to the next two weeks announcements. You know what I refer to ;-)

Thank you for the support Jim!

E 12°55'05.63"
N 56°04'39.26"

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-06-25 : 07:11:08

quote:
Originally posted by Transact Charlie

maybe "Enterprise Level"

Are you never going to let this "Entry Level DBA" thing lie. I think mr. Fang has left the building......

Nah. I am going to beat that into the ground. The irony of the statement is just too, too delicious to let it go.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-25 : 10:06:33

Bill, what happens after 32767 posts?

SELECT TOP 1	member_name
FROM		members
ORDER BY	posts DESC

Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type smallint.

E 12°55'05.63"
N 56°04'39.26"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-25 : 10:09:09

your posts will be reset to 0 on the 32768th post

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

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources