May 10, 2014 at 12:25 pm
Comments posted to this topic are about the item Bean Counting
May 10, 2014 at 12:25 pm
Nice question.
May 11, 2014 at 11:46 pm
There is learning in every QOTD. thanks for the question
May 12, 2014 at 12:32 am
Nice question thanks for sharing.
May 12, 2014 at 1:09 am
Unbelievable!!!
Someone get it wrong!
May 12, 2014 at 1:23 am
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
May 12, 2014 at 1:28 am
twin.devil (5/12/2014)
Nice question thanks for sharing.
to err is human
May 12, 2014 at 1:43 am
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
May 12, 2014 at 2:17 am
Nice idea, but there were not enough options. Just looking at the first select gave the answer.
May 12, 2014 at 2:22 am
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.
May 12, 2014 at 2:30 am
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
May 12, 2014 at 2:36 am
twin.devil (5/12/2014)
Nice question thanks for sharing.
+1
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
May 12, 2014 at 2:37 am
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
May 12, 2014 at 2:48 am
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
May 12, 2014 at 2:54 am
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
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy