|
|
-
commonly asked C# interview questions and answers...
|
-
This challenge is about finding second highest salary for each department...
|
-
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|
|
|
|
|
-
Mazhar Ehsan Commented 3 Years ago through Puzzles
@Sergejack
Why! This point was discussed and clarified in this forum by the challenge author Dave and later was updated in the challenge difinition page itself as folows:
http://beyondrelational.com/blogs/tc/archive/2010/06/28/TSQL-Challenge-33-Calculate
|
-
Mazhar Ehsan Commented 3 Years ago through Puzzles
[quote user="puzzles"]We have changed the data according to your suggestions and going to start logic testing.
[/quote]Thanks for correcting the tricky data and modifying it by adding 0 and negative values.Yet, it is still not sufficiently tricky as I
|
|
|
-
Mazhar Ehsan Commented 3 Years ago through Puzzles
Also note that "what time things happen" does never matter in this challenge. It has already been discussed and finalized. Please correct me if I am wrong.
|
-
Mazhar Ehsan Commented 3 Years ago through Puzzles
@LeszekAs per the rule quoted by you the expected result is showing only the first day data8 20100102
@dishdy
I am sorry but could you please explain"This is because on the first day it does not matter what time things happen"
In fact, whatever matte
|