-
Is a SubQuery Possible
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules