InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:29:16 GMT20http://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspx[quote][b]Kingston Dhasian (11/7/2012)[/b][hr][quote][b]CELKO (11/6/2012)[/b][hr]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. [/quote]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.[/quote]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."Wed, 07 Nov 2012 06:34:32 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspx[code="sql"]SELECT ID=ID, NAME=NAME, SALARY=SALARY, SALARY2=(case when SALARY-1000=0 then null else SALARY-1000 end) FROM SalaryDetail [/code]Wed, 07 Nov 2012 03:26:06 GMTcarlosaamaralhttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspxThe inner join wont work where Id 1 which needs to return a NULL value, based on the sample data provided, so you would need a Left outer join, to the prior record based on Id.Wed, 07 Nov 2012 02:38:36 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspxUsing inner join A.id=B.id-1Using cte expression and joinWed, 07 Nov 2012 02:33:57 GMTSony Francis @EYhttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspxI think the question is to see if you know how to transpose rows to columns.Wed, 07 Nov 2012 02:25:23 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspxI think they were probably testing your knowledge of Joins, it would be interesting to see what you think the solution is before putting up how I would have coded.Wed, 07 Nov 2012 02:07:07 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspx[quote][b]CELKO (11/6/2012)[/b][hr]...Now we have to track down this interview so we can tell them that you cheat...dishonesty...[/quote]So, can you claim that you have never-ever lied yourself? ;-) I guess OP had the interview already, and couldn't answer the question he is asking to help with...Wed, 07 Nov 2012 01:52:34 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspx[quote][b]CELKO (11/6/2012)[/b][hr]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. [/quote]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.Wed, 07 Nov 2012 01:50:56 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspx[quote][b]vs.satheesh (11/6/2012)[/b][hr]I face one interview question.One salary table i have three column like (id,name,salary)Table Name:SalaryDetailid name salary1 arun 10002 jothi 20003 kavi 30004 rahul 40005 jeeva 5000In this above i want following resultid name salary Salry21 arun 1000 null2 jothi 2000 10003 kavi 3000 20004 rahul 4000 30005 jeeva 5000 4000.Please reply this .[/quote]What is the business logic by which you got the 4th column( Salry2 )?Though it is a bit evident, it would be better if you put it in words as otherwise people would only be guessingAdditionally, if you include some code which you have come up with, we can be assured we are not spoon feeding youWed, 07 Nov 2012 01:46:31 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspx>> I face one interview question. One salary table I have three columns like (id,name,salary) <<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. Oh, you forgot the DDL that is minimal Netiquette. CREATE TABLE Salary_Details(emp_id INTEGER NOT NULL PRIMARY KEY, emp_name VARCHAR(25) NOT NULL, salary_amt DECIMAL (8,2) NOT NULL CHECK ( salary_amt >= 0.00) );>> In this above I want following result <<What is the business rule for the computation? Tue, 06 Nov 2012 18:13:21 GMTCELKOhttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspxSo, what do you have so far?Tue, 06 Nov 2012 17:01:36 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1381751-392-1.aspxI face one interview question.One salary table i have three column like (id,name,salary)Table Name:SalaryDetailid name salary1 arun 10002 jothi 20003 kavi 30004 rahul 40005 jeeva 5000In this above i want following resultid name salary Salry21 arun 1000 null2 jothi 2000 10003 kavi 3000 20004 rahul 4000 30005 jeeva 5000 4000.Please reply this .Tue, 06 Nov 2012 16:59:14 GMTvs.satheesh