All pastes #905582 Raw Edit

Untitled

public sql v1 · immutable
·published 2008-02-15 21:50 UTC
rendered paste body
Select CustNumberFrom InvoiceWhere EXISTS(  Select CustNumber  From INVOICE x (NOLOCK)  Where x.CustNumber = Invoice.CustNumber and x.InvNumber > Invoice.InvNumber and (x.OrderDate - Invoice.OrderDate) <= 90  Group By CustNumber  Having Count(*) >= 4 and ((MAX(OrderDate) - Min(OrderDate)) > 30))Group By CustNumberOrder By CustNumber