Jeff,
I stand corrected.  Old dogs and new tricks.

create table #tmp
(
    number int
)

insert into #tmp (number) values (1)
insert into #tmp (number)...

I have used subreports to cause page breaks before.  Don't know if that can help you or not.

Problem is that your temp table #price is local.  It will not be in scope for the dynamic SQL.  If you changed it to a global temp table then you...

2 CPU's with 8 cores each.  192 GB RAM.  tempDB has 20 data files each 5 GB in size.  Both the data and log files for tempDB are on their...