You can also use the OUTPUT clause to populate the "audit/history" table

CREATE TABLE #Table (
  SomeInt INT NOT NULL
, SomeString VARCHAR(20)...

Nice Chris

Just one small change to your script
Need to change MIN(ENDDATE) to MAX(ENDDATE)

SELECT ACCOUNT, PROGRAM, STARTDATE = MIN(STARTDATE), ENDDATE = MAX(ENDDATE)
FROM (
...

After re-reading my post from last night, I notice that the solution will only work if STARTTIME is always unique.
Below is a modified query that will handle multiple ACCOUNT,...

This is a classic Islands problem - You can Google for "SQL Gaps and Islands" for other examples

Test Data

CREATE TABLE #TEMP(ACCOUNT VARCHAR(15),STAFF VARCHAR(10),PROGRAM VARCHAR(10),STARTDATE...

The following code in a separate file per table, means that the entire file is deployed each time there is a change.  It is also re-runnable.
If there is...

Use EXCEPT to find the mismatched.
UNPIVOT those rows, and Use EXCEPT again.

Create a trigger that updates the value of confirmDate