Peter, I think you're on right track, but there is a flaw. The initial sample data does not show it, but when used with date range of 6/12 - 7/01 this data does:

INSERTdbo.#Events (LinkRL4, ProcessDate, UserName, SequenceNumber, JobDescription, EntryType, ChangingField)

VALUES (111, '2014-06-01', 'Michael', 1, 'Daily', 'INSERT', 'GM'),

(111, '2014-06-09', 'Michael', 12, 'Daily', 'UPDATE', 'GMC'),

(111, '2014-06-15', 'Rachel', 19, 'Daily', 'UPDATE', 'GMotors'),

(111, '2014-07-01', 'Rachel', 24, 'Daily', 'UPDATE', 'Motors'),

(111, '2014-07-05', 'Rachel', 39, 'Daily', 'UPDATE', 'GenMotors');

INSERT dbo.#Events (LinkRL4, ProcessDate, UserName, SequenceNumber, JobDescription, EntryType, ChangingField)

VALUES (112, '2014-06-04', 'Thomas', 6, 'Daily', 'INSERT', 'MB'),

(112, '2014-06-07', 'Thomas', 10, 'Daily', 'UPDATE', 'Mercedes'),

(112, '2014-06-15', 'Thomas', 20, 'Daily', 'UPDATE', 'MBenz'),

(112, '2014-07-03', 'Michael', 27, 'Daily', 'UPDATE', 'Benz'),

(112, '2014-07-05', 'Rachel', 40, 'Daily', 'UPDATE', 'Mer Benz');

INSERT dbo.#Events (LinkRL4, ProcessDate, UserName, SequenceNumber, JobDescription, EntryType, ChangingField)

VALUES (113, '2014-07-06', 'Michael', 55, 'Daily', 'INSERT', 'BMW');

INSERT dbo.#Events (LinkRL4, ProcessDate, UserName, SequenceNumber, JobDescription, EntryType, ChangingField)

VALUES (114, '2014-06-01', 'Steve', 4, 'Daily', 'INSERT', 'VW'),

(114, '2014-06-02', 'Steve', 60, 'Daily', 'UPDATE', 'Volks');

INSERT dbo.#Events (LinkRL4, ProcessDate, UserName, SequenceNumber, JobDescription, EntryType, ChangingField)

VALUES (115, '2014-06-01', 'Stan', 2, 'Daily', 'INSERT', 'BMW'),

(115, '2014-06-02', 'Stan', 3, 'Daily', 'UPDATE', 'Beamer'),

(115, '2014-08-02', 'Stan', 80, 'Daily', 'UPDATE', 'BMW');

INSERT dbo.#Events (LinkRL4, ProcessDate, UserName, SequenceNumber, JobDescription, EntryType, ChangingField)

VALUES (116, '2014-06-25', 'Lee', 32, 'Daily', 'INSERT', 'BMW'),

(117, '2014-08-02', 'Lee', 81, 'Daily', 'UPDATE', 'BMW');

GO