Comments by Member 10239648 (Top 1 by date)

Actually its not a dynamic query.
Requirement is to put current year data in [Primary] filegroup rest year data there in the respective month_year group.
At year end, means on 1Jan'17, data should be in [Primary] for the Jan'2017 and 2016 data moved to respective file groups of month.