How would I do this sub-select?

From: <dan_at_nospam.com>
Date: Wed, 14 Jan 2009 09:49:32 -0600
Message-ID: <496e098c$0$89868$815e3792_at_news.qwest.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 Received on Wed Jan 14 2009 - 16:49:32 CET

This message: [ Message body ]
Next message: Bob Badour: "Re: How would I do this sub-select?"
Previous message: Walter Mitty: "Re: Search efficiency - RDMS search versus free text search"
Next in thread: Bob Badour: "Re: How would I do this sub-select?"
Reply: Bob Badour: "Re: How would I do this sub-select?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message