How would I do this sub-select?
Date: Wed, 14 Jan 2009 09:49:32 -0600
I need to do "For each customer identified by Cust_ID sum last 90 days of Sales from Monday for each Monday going back 365 days" and return 'Monday_Date', 'Cust_ID', 'Sales_Last_90_Days'. I am going against MS SQL Server 2000. Need some help with the SQL.
Thanks! -- dan Received on Wed Jan 14 2009 - 09:49:32 CST