Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Query Expand / Collapse
Author
Message
Posted Saturday, April 5, 2008 4:59 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 4, 2009 4:44 AM
Points: 75, Visits: 8
Comments posted to this topic are about the item Query
Post #480437
Posted Saturday, April 5, 2008 9:02 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 31, 2014 8:20 AM
Points: 393, Visits: 87
mmm...

isn't correct!
"month(dob) in (1,2,3,4,5,8)"
What is "dob"???? ;)

if in the secord option, call the date "join_name":
datename(m,join_date) like '%a%'

and, the second option is right only in english version

give me my points!!! :P



Greetings From Argentina!

Pablo

Post #480442
Posted Sunday, April 6, 2008 2:45 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 8:54 AM
Points: 522, Visits: 466
I am pretty upset about the fact that the questions posted doesn't seem to be appropraitely matching with the options specified in the list of answers.

I don't seem to understand what is dob column in the answer option.

Post #480469
Posted Sunday, April 6, 2008 8:05 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 23, 2012 2:48 PM
Points: 70, Visits: 57
I agree with Pablo! And yes, I want my point too!

Vic
www.vicrauch.com
Post #480486
Posted Sunday, April 6, 2008 2:09 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 5:05 PM
Points: 2,644, Visits: 824
Yeah, 'dob? WTF is 'dob'? Commonly it's short for 'date of birth', which has nothing to do with when an employee joined a company.





Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Post #480515
Posted Sunday, April 6, 2008 8:12 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 12, 2011 12:48 PM
Points: 86, Visits: 58
dob ?? :D

what is the 'dob' of the author of this question ?
Post #480544
Posted Sunday, April 6, 2008 8:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 23, 2013 1:06 AM
Points: 9, Visits: 41
Apart from the fact that I dont know about the elusive 'dob' as well, I am also wondering that the explaination that was given in the right answer "each of the months have one 'a' atleast once" will only be right if the ENTIRE name of the month is taken into consideration.

This will fail if only "Feb" as a string or month name is passed.

Post #480550
Posted Sunday, April 6, 2008 11:04 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 7:57 AM
Points: 2,697, Visits: 89
The question ask only for those employees Who joined in the month of Jan, Feb, March, April, May, Aug from table employee having a field of join_date where as the correct answers tells that "month(dob) in (1,2,3,4,5,8)" will also give the required data which is not correct. (normally "dob" denotes to Date of Birth)

The other answer " datename(m,join_date) like '%a%' " is also not correct as it will not give the list of employees who joined in the month of FEB

Since both " month(dob) in (1,2,3,4,5,8), datename(m,join_date) like '%a%' " answer are not correct, the last answer "Not in List" is the correct answer.

I nee my points.




Warm Regards,

Jignesh Mehta

Post #480586
Posted Monday, April 7, 2008 12:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 10, 2014 6:56 AM
Points: 1,176, Visits: 878
The question asks for join_date, not dob, so first answer is incorrect.
datename(m,) returns full name of month, which gives correct result for few languages, but not all, so it's also incorrect, resulting in "not in list" as the only correct answer.

Yet another poor QoD. They're meant to be fun, not to upset participants.
Post #480616
Posted Monday, April 7, 2008 1:06 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:00 PM
Points: 633, Visits: 363
Yeah! I agree with all of the above!

I do thank you for all the questions that are insightful (and correct). It's an ego bruising event when you get something wrong so these one's really suck!

How can something that was not included in the question be referenced as a correct answer (dob) - even if it was supposed to mean date_of_beginning!

Better luck tomorrow!
Post #480618
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse