-
The challenge is to find the Tax Code based on Price. There is a table called "LineItems" that have Invoice Number and Price. There is another table "Sales" that contains Invoice Number, Amount and Tax Code. Each sales amount is uniquely made up by the sum of one or more prices. Based...
-
Just published a sandbox for the basic testing of TSQL Challenge 79 - Finding the Islands . http://beyondrelational.com/puzzles/tsql/challenges/79/basic-testing-sandbox.aspx
-
Just published a sandbox for the basic testing of TSQL Challenge 77 - Transforming monthly resource efforts into weekly actuals . http://beyondrelational.com/puzzles/tsql/challenges/77/basic-testing-sandbox.aspx
-
The challenge is to create a query for a report that shows expiring material. http://beyondrelational.com/puzzles/challenges/108/find-the-expiring-quantity-of-material.aspx
-
The challenge is to wrap long text sequences to a specified overall width (wrap position) - similar to columns in a newspaper. http://beyondrelational.com/puzzles/challenges/107/implement-word-wrapping-in-tsql.aspx
-
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week. http://beyondrelational.com/puzzles/challenges/106/calculate-the-payroll-hours-of-employees.aspx
-
Many of you must have played the 'mangled words' game in the school. Here is a challenge that gives you an opportunity to play it once again using TSQL. Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a...
-
This challenge invites you to identify the longest sequence of alphabets from a string. This challenge is Version 2 of the TSQL Challenge 67 . The difference is that in this version, you should apply circling while finding the longest sequence. http://beyondrelational.com/puzzles/challenges/104/find...
-
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table. This challenge is Version 2 of the TSQL Challenge 66 . This...
-
This challenge invites you to Generate kaprekar kernel or series from numbers. http://beyondrelational.com/puzzles/challenges/102/generate-kaprekar-kernel-or-series-from-numbers.aspx
-
This challenge invites you to identify the longest sequence of alphabets from a string. http://beyondrelational.com/puzzles/challenges/101/find-the-longest-sequence-of-alphabets-in-a-string.aspx
-
I was working on database design stuff and came across a situation where in i had to get all the primary keys existing in database for all tables and the primary key columns and column details. It would be very had and insane to go into each table and search for PK and its data. So i came up with this...
-
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table. http://beyondrelational.com/puzzles/challenges/100/find-the...
-
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial transactions. This is not a very complicated challenge and there are different ways to solve this. The key here is to see some of the very efficient logical approaches to solve...
-
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays. http://beyondrelational.com/puzzles/challenges/98/a-payroll-calculation-challenge.aspx