Thank this author by sharing:
By Jacob Sebastian, 2012/01/23
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
password expired
Timeout expired
Provide material for 70-448
Need SSAS Materials link
Password expired
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com