Re: How would I do this sub-select?

Bob Badour wrote:
> dan_at_nospam.com wrote:
>

>> 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

Here is what I have:

SELECT Custid, Invoicedate AS Monday_Date,

    (SELECT Sum(R_Sales) FROM Order_Header_Invoice AS T2 WHERE

     T2.Invoicedate <= T1.Invoicedate AND T2.Invoicedate >=
     DateAdd(day, -90, T1.Invoicedate) ) AS Sales_L90D

FROM Order_Header_Invoice AS T1 WHERE ( DatePart(weekday, Invoicedate) = 2 AND Invoicedate >= DateAdd(day, -365, getdate()) ) GROUP BY Custid, Invoicedate
ORDER BY Custid, Invoicedate DESC

but I get a "Timeout Expired" error. Is this causing an infinite loop? Received on Wed Jan 14 2009 - 18:05:38 CET