PDA

View Full Version : Is a SubQuery Possible



stanl
06-04-2008, 03:40 AM
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