Intresting Question need answer ASAP

Question

Post reply

Intresting Question need answer ASAP

Viewing 15 posts - 31 through 45 (of 46 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

I guess I found some shorter and obscure enough one!

SELECT EXP($)

It's only 13 characters long and no numbers :hehe:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Dwain Camps SSC Guru Points: 86913 More actions · Answer 2

Still a tie then:

SELECT DAY($)

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

dwain.c (9/21/2012)
Still a tie then:
SELECT DAY($)

I thought the Cup is given to whoever comes first...

:hehe:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 4

David Moutray (9/20/2012)
Well, let's be charitable and assume that he is suitably embarrassed by his behavior.

Heh... I WAS being charitable. So far as him being embarrassed goes... probably not because he has the answers he was looking for. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Dwain Camps SSC Guru Points: 86913 More actions · Answer 5

Eugene Elutin (9/21/2012)
dwain.c (9/21/2012)
Still a tie then:
SELECT DAY($)
I thought the Cup is given to whoever comes first...
:hehe:

I'll settle for an honorable mention.

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 6

SELECT COS($)

Will do the same, but it's to obvious...

I think the harder question would be: How to return 4 without using number in SELECT,

finding SELECT LEN($), would be a bit more trickier than applying math function...

😀

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Dwain Camps SSC Guru Points: 86913 More actions · Answer 7

Eugene Elutin (9/21/2012)
SELECT COS($)
Will do the same, but it's to obvious...
I think the harder question would be: How to return 4 without using number in SELECT,
finding SELECT LEN($), would be a bit more trickier than applying math function...
😀

And the beauty of the problem with 4 as the result is that there may only be one solution.

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

PaulB-TheOneAndOnly SSC Guru Points: 66773 More actions · Answer 8

Eugene Elutin (9/21/2012)
dwain.c (9/21/2012)
Still a tie then:
SELECT DAY($)
I thought the Cup is given to whoever comes first...
:hehe:

No if second one hits you on the head with a frypan and runs away with the trophy 😀

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 9

dwain.c (9/21/2012)
Eugene Elutin (9/21/2012)
SELECT COS($)
Will do the same, but it's to obvious...
I think the harder question would be: How to return 4 without using number in SELECT,
finding SELECT LEN($), would be a bit more trickier than applying math function...
😀
And the beauty of the problem with 4 as the result is that there may only be one solution.

Not really, there are few variations:

SELECT LEN(£)

SELECT LEN(€)

...

:hehe:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

sestell1 SSChampion Points: 10230 More actions · Answer 10

Hmm, I couldn't think of anything shorter. I wanted to find a way to implicitly convert PI to a bit, but apparently there's no bit literal in SQL Server.

I went for convoluted instead:

SELECT Round(SQRT(PI()),$,@@SPID)

Paul White SSC Guru Points: 150457 More actions · Answer 11

I think the answer P.D. is after is [font="Courier New"]SELECT COUNT(*)[/font] It's not the shortest, though.

edit: Sorry I see 'mickyT' already mentioned this.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

adrian.facio SSCrazy Points: 2406 More actions · Answer 12

adrian.facio

SSCrazy

Points: 2406

September 24, 2012 at 9:45 am

#1541478

select count(*)

too late ha ha ha

Lowell SSC Guru Points: 323482 More actions · Answer 13

are procedures banned from this, ie you can only use a select?

you could do it in a single characet then:

CREATE PROC z

AS

SELECT cos('')

GO

z

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mickyT SSChampion Points: 10360 More actions · Answer 14

Shame there isn't implicit conversion for money to int in the following

SELECT -(~$) It would have made a good answer

David Moutray SSCertifiable Points: 5704 More actions · Answer 15

Yes! That would have been great. I don't think you even need the parentheses. That answer would be nigh unbeatable. (Too bad it doesn't work. :hehe:)