SQLServerCentral Article

TSQL Challenge 74 - Find the expiring quantity of material

,

TSQL Challenge 74 - Find the expiring quantity of material

The challenge is to create a query for a report that show expiring material. There is a table with material that have a expiry date. Another table holds request for the expiring material. You need to show how much material will be expiring that do not have request in queue for.

http://beyondrelational.com/puzzles/challenges/108/find-the-expiring-quantity-of-material.aspx

Rate

Share

Share

Rate