cte

I'm having trouble wrapping my head around Recursive CTE's in SQL Server. My dataset (simplified version below for copy/paste) is a large table containing hundreds of thousands of chains. Each chain is made up of a number of components, linked together in a specific order for each chain. I've...