This challenge is based on a problem discussed in the MSDN TSQL forum. The challenge is to create a query for a report that shows expiring material. There is a table with material that has expiry dates. Another table holds requests for the expiri

please provide the solution

v2 2008R2 ok, just found and used Stefan_G's trick to materialize data

v2 2008R2 ok, just found and used Stefan_G's trick to materialize data

v2 2008R2 ok, just found and used Stefan_G's trick to materialize data

This challenge is based on a problem discussed in the MSDN TSQL forum. The challenge is to create a query for a report that shows expiring material. There is a table with material that has expiry dates. Another table holds requests for the expiri

Slow solution becouse of recursive cte but with correct results It is possible to do that without recursive on 2008R2?

Huh, actually it is slow not because of recursive cte but all calculation and steps before recursive cte

Maxim is your solution for MS2012 or 2008? anyway can you share this for me? I posted solution with correct results when using castling sample data script
and 2008R2 but seems slow to me and can't figure out how to make it without recursive cte