Need to query for a report that show expiring material. Basically I have a table with material that have a expiry date. Then I have another table holds request for the expiring material. I need to show how much material will be expiring that do not have request in queue for.

The challenge is to wrap the text by specified position. The key point is you are not allowed to break the word. When the wrapping position is in between the word, you should wrap the text by the space before the word. When the first word in sentence is longer than the postion specified to wrap, the word should be wrapped by appending dash (-) to the word.

This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.

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 'dictionary' table. You might be able to create more than one correct word from some of the input strings. It is also possible that a mangled word is completely incorrect and no valid word can be created from it.

As an example, given "xtet", the valid word that can be formed is "text".

This challenge invites you to identify the largest sequence of alphabets from a string.

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 invites you to Generate kaprekar kernel or series from numbers.

This challenge invites you to identify the largest sequence of alphabets from a string.

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 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 the Running Total problem.