Bean Counting

Question

Post reply

Bean Counting

PHYData DBA

SSCertifiable

Points: 7541
More actions
May 10, 2014 at 12:25 pm

#396731

Comments posted to this topic are about the item Bean Counting

Viewing 15 posts - 1 through 15 (of 32 total)

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

robert_verell Say Hey Kid Points: 668 More actions · Answer 1

robert_verell

Say Hey Kid

Points: 668

May 10, 2014 at 12:25 pm

#1712408

Nice question.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 2

There is learning in every QOTD. thanks for the question

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

Umer Akram

SSC-Insane

Points: 22209

May 12, 2014 at 12:32 am

#1712536

Nice question thanks for sharing.

Carlo Romagnano SSC-Insane Points: 22670 More actions · Answer 4

Carlo Romagnano

SSC-Insane

Points: 22670

May 12, 2014 at 1:09 am

#1712539

Unbelievable!!!

Someone get it wrong!

😀

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 5

It is also possible to get a result 1000,200000,199000,1,1 as the data type of lastupdatedatetime is not stated nor is the value. The question says that a single value is shared but that could be 0.

Fitz

- my job is to be awkward

Umer Akram SSC-Insane Points: 22209 More actions · Answer 6

twin.devil (5/12/2014)
Nice question thanks for sharing.

to err is human 🙂

rhythmk SSCertifiable Points: 7271 More actions · Answer 7

Nice and easy one.One can answer by seeing the first query itself.No need to see other query as only one option has answer as 1000 for first query 🙂

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

Toreador SSChampion Points: 11366 More actions · Answer 8

Nice idea, but there were not enough options. Just looking at the first select gave the answer.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

Thank you for the post, good one.

Easy Monday... so tough Friday... I presume...

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 10

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

twin.devil (5/12/2014)
Nice question thanks for sharing.

+1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 12

Carlo Romagnano (5/12/2014)
Unbelievable!!!
Someone get it wrong! 😀

And now it`s 34 got it wrong 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 13

rhythmk (5/12/2014)
Nice and easy one.One can answer by seeing the first query itself.No need to see other query as only one option has answer as 1000 for first query 🙂

+1

Hany Helmy SSChampion Points: 13921 More actions · Answer 14

In the question, it`s mentioned the column name is: Lastupdatetime, but in the code, it`s Lastupdatedatetime 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant