Nice Article,

there is a small mistake in the code though.

WITH rCTE AS(

SELECT g.ClientId, g.GroupId, g.MemberId, h.PreviousGroupId, h.PreviousMemberId

FROM hft.Groups g

...