http://beyondrelational.com/blogs/tcb/default.aspxenCommunityServer 2008.5 SP1 (Build: 31106.3070)http://beyondrelational.com/blogs/tcb/archive/2010/03/01/TSQL-Beginner_2700_s-Challenge-2-_2D00_-Fight-Your-Fear-for-Date-Calculations.aspx#3649Thu, 25 Feb 2010 07:58:02 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:3649Niladri Biswas<p>Hi Divya &amp; Jacob,</p> <p>Appreciate if you can let me know about the exceptional cases that needs to be handle in this challenge.</p> <p>Regards</p> <p>Niladri Biswas</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=3649" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/10/13/tsql-beginner-s-challenge-1-find-the-second-highest-salary-for-each-department.aspx#1830Tue, 01 Dec 2009 20:50:10 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1830nhasan<p>DECLARE @Employees TABLE</p> <p>(</p> <p> &nbsp; &nbsp;EmployeeID INT IDENTITY,</p> <p> &nbsp; &nbsp;EmployeeName VARCHAR(15),</p> <p> &nbsp; &nbsp;Department VARCHAR(15),</p> <p> &nbsp; &nbsp;Salary NUMERIC(16,2)</p> <p>)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;T Cook&#39;,&#39;Finance&#39;, 40000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;D Michael&#39;,&#39;Finance&#39;, 25000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;A Smith&#39;,&#39;Finance&#39;, 25000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;D Adams&#39;,&#39;Finance&#39;, 15000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;M Williams&#39;,&#39;IT&#39;, 80000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;D Jones&#39;,&#39;IT&#39;, 40000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;J Miller&#39;,&#39;IT&#39;, 50000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;L Lewis&#39;,&#39;IT&#39;, 50000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;A Anderson&#39;,&#39;Back-Office&#39;, 25000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;S Martin&#39;,&#39;Back-Office&#39;, 15000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;J Garcia&#39;,&#39;Back-Office&#39;, 15000)</p> <p>INSERT INTO @Employees(EmployeeName, Department, Salary)</p> <p>VALUES(&#39;T Clerk&#39;,&#39;Back-Office&#39;, 10000)</p> <p>SELECT</p> <p> e.EmployeeID,</p> <p> e.EmployeeName,</p> <p> e.Department,</p> <p> e.Salary</p> <p>FROM</p> <p> @Employees e</p> <p>WHERE</p> <p> (SELECT</p> <p> COUNT(DISTINCT e2.Salary) </p> <p> FROM</p> <p> @Employees e2</p> <p> WHERE</p> <p> e2.Department = e.Department AND</p> <p> e2.Salary &gt;= e.Salary</p> <p> GROUP BY</p> <p> e2.Department) = 2</p> <p>ORDER BY</p> <p> e.Salary</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1830" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/10/13/tsql-beginner-s-challenge-1-find-the-second-highest-salary-for-each-department.aspx#1782Tue, 01 Dec 2009 06:56:39 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1782Pankaj Kumar Verma<p>HI jacob,</p> <p>I have also submitted my script of the challenge #1. Please check this and let me know is it OK.</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1782" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/10/13/tsql-beginner-s-challenge-1-find-the-second-highest-salary-for-each-department.aspx#1414Fri, 30 Oct 2009 06:43:20 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1414arorasumitcs<p>True one Niladri.. but what you think what you did, you even send the whole explanation in comments with your solution and you blaming other peoples.</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1414" width="1" height="1">http://beyondrelational.com/blogs/tcb/pages/tsql-beginner-s-challenge-submission-guidelines-and-terms.aspx#1346Tue, 20 Oct 2009 07:32:35 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1346Niladri Biswas<p>Hi Tejas,</p> <p>I have tried to give explanation for the TBC #1 but I was unable to upload the images. Is there any otehr way where I can send a full document of explanation.</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1346" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/10/13/tsql-beginner-s-challenge-1-find-the-second-highest-salary-for-each-department.aspx#1313Sun, 18 Oct 2009 16:14:17 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1313Jacob Sebastian<p>Srinivas,</p> <p>Please read submission Guidelines at <a rel="nofollow" target="_new" href="http://beyondrelational.com/blogs/tcb/pages/tsql-beginner-s-challenge-submission-guidelines-and-terms.aspx">beyondrelational.com/.../tsql-beginner-s-challenge-submission-guidelines-and-terms.aspx</a></p> <p>It has clear instructions on how to submit the solution.</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1313" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/10/13/tsql-beginner-s-challenge-1-find-the-second-highest-salary-for-each-department.aspx#1312Sun, 18 Oct 2009 16:13:51 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1312Jacob Sebastian<p>Mudit,</p> <p>Temp tables are not allowed. </p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1312" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/09/22/first-editorial-t-sql-challenges-beginners.aspx#1305Thu, 15 Oct 2009 23:19:03 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1305Vijaya Krishna Kadiyala<p>Kool..dude..wish you all the best..</p> <p>Thanks -- Vj</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1305" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/10/13/tsql-beginner-s-challenge-1-find-the-second-highest-salary-for-each-department.aspx#1291Thu, 15 Oct 2009 08:36:39 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1291srinivas<p>i was able to solve this puzzle, but where can i post my solution.</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1291" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/10/13/tsql-beginner-s-challenge-1-find-the-second-highest-salary-for-each-department.aspx#1275Wed, 14 Oct 2009 13:45:34 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:1275Mudit.Gupta<p>Jacob,</p> <p>Can we use Temp tables instead of Table Variables for this task?</p> <p>thanks!</p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=1275" width="1" height="1">http://beyondrelational.com/blogs/tcb/archive/2009/09/17/tsql-challenges-for-beginners-the-team-interview-with-tejas-shah.aspx#887Thu, 17 Sep 2009 07:23:03 GMT6e5011fa-7db5-4df3-bb79-9085c1d333b3:887Ritesh Shah<p>Congratulations Tejas for being a part of TSQL Challenges for Beginners.</p> <p>Ritesh Shah</p> <p><a rel="nofollow" target="_new" href="http://www.SQLHub.com">http://www.SQLHub.com</a></p> <div style="clear:both;"></div><img src="http://beyondrelational.com/aggbug.aspx?PostID=887" width="1" height="1">