Thanks guys and specially GSquared,

The Numbers table worked perfectly for me but I want to have my leading zero back in the PK field. Like I explained above, I'm dealing...

Thanks SSCommitted,

May be I wasn't clear enough here. I may have to loop trough 3 time and increment by 1. So from 2102721210016 I will get the following:

2102721210016

2102721210017

2102721210018

2102721210019

I think I...

Why don't you do a linked server then write some select statements using openquery to get your data into sql.