'Number filling'

  • Thread starter Thread starter Edwin Knoppert
  • Start date Start date
E

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!
 
Why do you need it in first place?
One way is to create a DataTable instance, add one column and add 12 rows
accordingly.
 
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..


Miha Markic said:
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/

Edwin Knoppert said:
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!
Click to expand...
Click to expand...
 
Back
Top