Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #13597
| From | Ron Weiner <rw@domain.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Create a Table - List of Numbers |
| Date | 2019-04-20 11:08 -0400 |
| Organization | WorksRite |
| Message-ID | <q9fcla$jee$1@dont-email.me> (permalink) |
| References | <rjalbe90nkq5r4vtflgbvvj03b5o6rfhk9@4ax.com> |
croy presented the following explanation : > I would like to create a table that is simply a list of numbers from 1 to > 100,000. > > Is there an easy way? Yes! You can do it with a MakeTable query that uses a Cartesian Product to actually create the numbers. Here is an example that makes 10K rows numbered from 0 to 9999. It can be easily modified to increase the number of rows to 100K. Oh... and it creates the table in an instant. SELECT (Ones.N+Tens.N+Huns.N+Thous.N) AS Num INTO tblNums FROM (Select 0 as N From MSysQueries Union Select 1 From MSysQueries Union Select 2 From MSysQueries Union Select 3 From MSysQueries Union Select 4 From MSysQueries Union Select 5 From MSysQueries Union Select 6 From MSysQueries Union Select 7 From MSysQueries Union Select 8 From MSysQueries Union Select 9 From MSysQueries) AS Ones, (Select 0 as N From MSysQueries Union Select 10 From MSysQueries Union Select 20 From MSysQueries Union Select 30 From MSysQueries Union Select 40 From MSysQueries Union Select 50 From MSysQueries Union Select 60 From MSysQueries Union Select 70 From MSysQueries Union Select 80 From MSysQueries Union Select 90 From MSysQueries) AS Tens, (Select 0 as N From MSysQueries Union Select 100 From MSysQueries Union Select 200 From MSysQueries Union Select 300 From MSysQueries Union Select 400 From MSysQueries Union Select 500 From MSysQueries Union Select 600 From MSysQueries Union Select 700 From MSysQueries Union Select 800 From MSysQueries Union Select 900 From MSysQueries) AS Huns, (Select 0 as N From MSysQueries Union Select 1000 From MSysQueries Union Select 2000 From MSysQueries Union Select 3000 From MSysQueries Union Select 4000 From MSysQueries Union Select 5000 From MSysQueries Union Select 6000 From MSysQueries Union Select 7000 From MSysQueries Union Select 8000 From MSysQueries Union Select 9000 From MSysQueries) AS Thous; Rdub --- This email has been checked for viruses by AVG. https://www.avg.com
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread
Create a Table - List of Numbers croy <hate@spam.invalid.net> - 2019-04-19 22:14 -0700
Re: Create a Table - List of Numbers Mike P <mikewpayne@tiscali.co.uk> - 2019-04-20 04:21 -0700
Re: Create a Table - List of Numbers croy <hate@spam.invalid.net> - 2019-04-20 17:54 -0700
Re: Create a Table - List of Numbers Ron Weiner <rw@domain.com> - 2019-04-20 11:08 -0400
csiph-web