I want to run a select query with a group by like:
Select MyText, MyDate
Group By MyText, MyDate
However I want to group each "MyText" with the Min(MyDate) and Min(MyDate) + 30 days.
So for example I want to select 3 records with the same "MyText" value and the 3 records have MyDate values of 01/01/2005, 01/10/2005 and 03/01/2005 I would return 2 records because the first record would be grouped with the first 2 dates with the first date showing and the second record would be only 03/01/2005 because it didn't fall within 30 days.