Ah but the issue is how many rows you can write into a table. That's a bit more work than a for loop :-)
Regards Greg Dr Greg Low SQL Down Under +61 419201410 1300SQLSQL (1300775775) On 11 Sep 2015, at 5:16 pm, Greg Keogh <[email protected]<mailto:[email protected]>> wrote: Assuming computing power doubles every 18-24 months, then that 5444 years will become a lot less, relatively quickly. I didn't mention that counting to 2^63 is eminently parallelizable, so lets divide up a small fraction of the free internet computing power on the problem and see how long it takes. I don't have any figures to even begin a rough calculation -- GK
