Grouped Records (Duplicate)

[learning_codes]

I have one problem with data because the data is little messy that I
need
to clean up easily.


EmpID JobID StartDate EndDate 2MosMoreInd
1 2222 676 01/01/08 01/31/08 Blank
2 2222 676 02/01/08 06/30/08 Y
3 2222 676 09/15/08 10/01/08 Blank
4 2222 676 12/15/08 02/09/09 Y


I'm looking for one record that collapse #1 and #2 because of one day
apart between #1 (End date) and #2 (StartDate).
#1 and #2 should show continue (Y) instead of #1 show 2MosMoreInd as
blank.


I'm interested to see #1 and #2 should be :


EmpID JobID StartDate EndDate 2MosMoreInd
2222 676 01/01/08 06/30/08 Y
(Grouped #1 and #2)
2222 676 09/15/08 10/01/08 Blank
(No change)
2222 676 12/15/08 02/09/09
Y (No change)


I would be appreciated if you provide me some help.


Thanks