Viewing 15 posts - 451 through 465 (of 552 total)
awesome read. 🙂
(there were some statements where I guess were added to create extra confusion... OR to make it more interesting... 😉 :rolleyes:)
November 13, 2012 at 1:29 am
Mike Dougherty-384281 (11/9/2012)
Does this example illustrate a Fail in the implementation/execution of coalesce()?...
November 9, 2012 at 7:53 am
Christian Buettner-167247 (11/9/2012)
Raghavendra Mudugal (11/9/2012)
Msg 4127, Level 16, State 1, Line 8
At least one of the arguments to COALESCE must be an expression that is not the NULL constant.
.. possibly...
November 9, 2012 at 5:46 am
Christian Buettner-167247 (11/9/2012)
The coalesce expects at least one typed NULL in order to execute and hence the error.
Simple...
November 9, 2012 at 2:03 am
Good one. 🙂
Even though knowing the answer (and I said it out loud) ....I made myself to execute the query to confirm.... :w00t: :crazy:
November 8, 2012 at 11:19 pm
🙂 Simply Nice.
(note: aliasing the columns in the first select statement will be enough)
November 4, 2012 at 1:43 am
Great question, thank you for posting.
🙁 (I am disappointed with myself, as my low self-esteem level is high normally.... today it is outstanding...)
November 2, 2012 at 8:36 am
😎 (actually I used extreme advanced skill to make the choice, and I still got it wrong.... but got to learn on load of things)
Awesome question. 🙂 Thank you Tom
November 2, 2012 at 7:59 am
Hugo Kornelis (10/30/2012)
john.arnott (10/30/2012)
Raghavendra Mudugal (10/30/2012)
(...)
If the OVER (Order By UserID) was used then XRAY will get the 50.00 as he is on the 5 position and...
November 2, 2012 at 7:06 am
🙂
Indeed a nice question, but for me it was "The Beginner's Luck" thing... good it used the only word "modifying..." in the BOL, and just went and selected UPDATE. :hehe:
(Although...
November 2, 2012 at 6:40 am
vk-kirov (10/30/2012)
...The value 50.00 does not appear in the results, so I see no problem with the answer given....
Just trying to understand...
As it says OVER (ORDER BY Sales) and EASY...
October 30, 2012 at 9:01 am
Hugo Kornelis (10/27/2012)
... to access the elements of a dot-seperated string. ...
ahhh..... now I am relieved...
Thank you Hugo. 😎
October 28, 2012 at 2:40 am
palotaiarpad (10/24/2012)
Select cast(100 as real) * 1.05,cast(cast(100 as real) * 1.05 as int);
-- Result is 105, 104
The result is very strange for me. Does SQL Server the...
October 24, 2012 at 2:07 am
Very interesting, thank you for the question.
(and Happy Dasara to all)
October 23, 2012 at 11:54 pm
Viewing 15 posts - 451 through 465 (of 552 total)