• Please refer below URL an article from Jeff Moden where he mentioned how to use Tally Table.

    http://www.sqlservercentral.com/articles/T-SQL/62867/

    Also just a suggestion don't use 'sp' as prefix for your user defined stored procs.