Assignment Changes L-SQL Query Issue

Hi all,

I've been using and adapting Julian's L-SQL query posted here:

to try and return previous roles for employees.

It all works great until we have someone who has two assignment changes in one change, see screenshot below:

This individual does not show on the report at all.

Does anyone have any ideas on how we can show employees with more than one Assignment Change in one change, so to speak?

Attached is the L-SQL I'm using.

Thanks!