I would suggest looking at Jeff Moden's function

Tally OH! An Improved SQL 8K “CSV Splitter” Function at http://www.sqlservercentral.com/articles/Tally+Table/72993/

Probably the best you will find out there: http://www.sqlservercentral.com/articles/Tally+Table/72993/

Check the article http://www.sqlservercentral.com/articles/Tally+Table/72993/

[font="Courier New"][/font]DECLARE @BatchStart datetime = GETDATE(), @StageStart datetime, @Iteration int = 0, @Iterations int = 5

PRINT 'Batch start: ' + CONVERT(varchar(12), DATEADD(ms, DATEDIFF(ms, @BatchStart, @BatchStart), 0), 114)

WHILE @Iteration <> @Iterations...