Real Life Dynamics Users updates their latest SQL script with an Order Count–YTD By User
SQL Scripts–Order Count–YTD By User « Real Life Dynamics User
Install, Upgrade & AdminSQL & DataDevelopment & Integration
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.