Christina Phillips shows off a Year Over Year Comparison in SQL.
Dynamics GP Land: Year Over Year Comparison in SQL
Archived post from 2013. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.