Delegate 1 has done Consent and SafeguardingChildren and so on the JOIN, I will get four records
Consent and the ConsentDate
Consent and the SafeguardingDate
Safeguarding and the SafeguardingDate
Safeguarding and the ConsentDate
Two of these records are incorrect. Perhaps my JOINS are not correct
For Delegate1, how many rows do you want to insert?
1 rows with two measure values and two measure dates.
2 rows each with a measure and a date and a measure type?
If 1 row, then you need some kind of pivot, perhaps insert the delegateID and update Consent columns, then the Safeguarding columns (in a staging table).
If 2 rows then maybe you need separate inserts. Join Delegate to Consent and insert. Join Delegate to Safeguarding and insert.