Query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Raghavan CV » Query

96 posts, Page 1 of 10

1 2 3 4 5 »»»

Query

Rate Topic

Display Mode

Topic Options

Author

Message

Raghav-673586

Posted Saturday, April 05, 2008 4:59 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 04, 2009 4:44 AM
Points: 75, Visits: 8

Comments posted to this topic are about the item Query

Post #480437

Pablo Rafael

Posted Saturday, April 05, 2008 9:02 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 7:48 AM
Points: 360, Visits: 78

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

arvindravish

Posted Sunday, April 06, 2008 2:45 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:01 AM
Points: 522, Visits: 358

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. Hehe

Post #480469

Vic Rauch-303403

Posted Sunday, April 06, 2008 8:05 AM

Valued 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

The CosmicTrickster

Posted Sunday, April 06, 2008 2:09 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:10 PM
Points: 2,605, Visits: 756

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

ChamilZ-622734

Posted Sunday, April 06, 2008 8:12 PM

SSC 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 ? Hehe

Post #480544

kohli.varun

Posted Sunday, April 06, 2008 8:45 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 16, 2012 5:21 PM
Points: 9, Visits: 37

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

Jignesh Mehta

Posted Sunday, April 06, 2008 11:04 PM

SSCrazy

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

Robert-378556

Posted Monday, April 07, 2008 12:55 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:40 AM
Points: 1,078, Visits: 847

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

vonHarry

Posted Monday, April 07, 2008 1:06 AM

SSChasing Mays

Group: General Forum Members
Last Login: Friday, March 15, 2013 5:54 PM
Points: 631, Visits: 325

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 »

96 posts, Page 1 of 10

1 2 3 4 5 »»»

Permissions