To add to previous solution. You would need a logic to repeat the data desired amount of times. This means that you need yo use Transact-SQL to do the job.
Perhaps the easiest way could be to create a stored procedure which would loop your data (in case you have multiple rows in the table) and then in another loop you would add the rows into the result set desired amount of times.
This could be done in a standard procedure or in a table valued function (for example
Using Table-Valued Functions in SQL Server[
^])
Submit an article or tip