Viswanathan Neelakantan explains Recursive Querying in SQL Server at Developing for Dynamics GP
Recursive Querying in SQL Server – Developing for Dynamics GP
SQL & DataInstall, Upgrade & Admin
Archived post from 2013. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.