I have a cross tab query set up to display the quantity of products ordered each date.
I want the query to dynamically show only the future 7 days as columns. So the query would return:
ProductName, 10/06/2010, 11/06/2010, 12/06/2010.
TestProduct, 0, 10, 25
I've tried using the PIVOT IN command...