Re: How would I do this sub-select?
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Wed, 14 Jan 2009 12:08:51 -0400
Message-ID: <496e0e15$0$5483$9a566e8b_at_news.aliant.net>
Date: Wed, 14 Jan 2009 12:08:51 -0400
Message-ID: <496e0e15$0$5483$9a566e8b_at_news.aliant.net>
> Hi,
>
> 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
Hi Dan,
Don't you think you will learn more if you do your own homework?