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 ««12

Reg: Interview Questions Expand / Collapse
Author
Message
Posted Wednesday, November 07, 2012 3:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 11:21 AM
Points: 29, Visits: 978
SELECT ID=ID,
NAME=NAME,
SALARY=SALARY,
SALARY2=(case when SALARY-1000=0 then null else SALARY-1000 end)
FROM SalaryDetail

Post #1381861
Posted Wednesday, November 07, 2012 6:34 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 PM
Points: 15,442, Visits: 9,588
Kingston Dhasian (11/7/2012)
CELKO (11/6/2012)
Now we have to track down this interview so we can tell them that you cheat. I have gotten two students and one lecturer kicked out of their schools for this kind of academic dishonesty.


How does the thread classify as "Academic dishonesty"?
The OP is most probably a job seeker and not a student. He is asking this question after the interview to gain some knowledge which he doesn't have now.
He would have been dishonest had he asked the question during the interview process which is highly unlikely.


Not at all unlikely. See it happen all the time.

That's why I always wait at least an hour from when these kinds of questions are posted before I post any sort of answer to the problem. Assuming some of the questions are homework, as opposed to interviews/tests, I sometimes wait a full day.

That way, if it's an honest "I came up short and I'd like some help so I can do better next time", they get what they need, but if it's a dishonest, "I'm in the middle of a test/interview and I'm trying to lie my way to (a better grade)/(a job I don't actually qualify for)", I'm not helping with that.

Either way, this one is too vague to actually provide real answers to. Are they trying to grab the value from the prior row? Are they looking for val-1000? Something else? It's too vague. In an interview, asked this exact question, I'd tell them my response would be, "The request is too vague. I need to know the actual business rules being applied here. Please contact the stakeholder and get the request clarified."


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1381947
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse