Hi Chris and Allen

Yes the data is aggregated ie 1 record for a row where the copies are 2,3 etc

Ive tried

declare @num_records int

set @num_records = 4

SELECT *

INTO #MyTable

FROM (

SELECT 123,...

thanks Chris

Its this part

SELECT 123, 1 UNION ALL

SELECT 456, 2 UNION ALL

SELECT 789, 1 UNION ALL

SELECT 789, 2 UNION ALL

SELECT 789, 3

Ive an issue with because my data will come...