'Number filling'

[Edwin Knoppert]

MDB, doing a max of a field which resultrs for example 12.
Now i want to simulate rows somehow (temptable?) with values 1 2 3 etc like:

1
2
3
4
5
6
7
8
9
10
11
12

It's all oledb asp.net 2, i'm not sure how to make such a temptable(memory
only) and fill this with 12 records via a query.
(This table is used in another query to make sure we have 12 periods, the
data we have might have period 1, 2, 10 etc.. but not all)

Thanks!

 

[Miha Markic [MVP C#]]

Why do you need it in first place?
One way is to create a DataTable instance, add one column and add 12 rows
accordingly.

 

[Edwin Knoppert]

I'm trying to prepare a single querystatement.
Select in select and such, so i can use and spread the query to someone
else.
Long story..

Why do you need it in first place?
One way is to create a DataTable instance, add one column and add 12 rows
accordingly.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

MDB, doing a max of a field which resultrs for example 12.
Now i want to simulate rows somehow (temptable?) with values 1 2 3 etc
like:

1
2
3
4
5
6
7
8
9
10
11
12

It's all oledb asp.net 2, i'm not sure how to make such a
temptable(memory only) and fill this with 12 records via a query.
(This table is used in another query to make sure we have 12 periods, the
data we have might have period 1, 2, 10 etc.. but not all)

Thanks!