ok many thanks, works fine, e needed to create table tally on my database not in tempdb like in the example