using a cursor to do this will be very slow, the better way seems to be to use a tally table and split the data up with this;

check out this excellent article on how to do this;

http://www.sqlservercentral.com/articles/TSQL/62867/