Working with a large SQL Server table of workorders. Assume two fields of importance custID and CloseDate [TimeStamp]. I need to query workorders where the same custID has been issued another workorder within 15 days of the previous close date.

Is this possible as a subquery, i.e. the result set would return grouped rows of custIDS and CloseDates if they occur within 15 days?

Stan