dispersion module sql in vb 2010 program

Hi all
I need to automate a kind of engine that do a row dispersion in a table based on a range of values.
The example im put it in a exel file, i hope i ilustrate what i need to do

thank you a lot

dispersion.xlsx
ErnestoAsked:
Who is Participating?
 
AkenathonCommented:
You definitely have to create the second table with the values... how else can the computer generate this sequence? If it's supposed to have some hidden logic behind it, let me know and we'll see what can be done

0,5
0,625
0,75
0,875
1
1,25
1.5
2
2,5
3
4
6
8
10
12
14
16
18
20
22
24
0
 
AkenathonCommented:
You are describing a join between the two first tables on your spreadsheet:

select * from main_values mv join disperse_values dv on mv.de = dv.de
where codigo = 'BBCDA0FE'
0
 
ErnestoAuthor Commented:
the second table records do not exist i need it to create by de  a  criteria in the 1 value that im have
thank you a lot
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
ErnestoAuthor Commented:
any idea to do so??
thank you a lot
0
 
AkenathonCommented:
Do what... create a table? Just ask your DBA to create a table with those values... depending on your DBMS, the syntax is something SIMILAR to:

create table some_table_name (
field_name_1 number,
field_name_2 date );

Then you populate the table with an INSERT statement. Again, the exact syntax is supposed to be standard but it can vary for each DBMS brand...
0
 
ErnestoAuthor Commented:
no , create the table no
do the dispersion1!!
0
 
AkenathonCommented:
What you call "dispersion" is a series of numbers which don't look like they can be generated by a single mathematical formula. Ask the person who decided which values are part of that series and see if he can prove otherwise. The good news is that you do NOT need that... just do several INSERT commands to add each of the values to the table ONE BY ONE. It will work!
0
 
ErnestoAuthor Commented:
Please see the excel that i submitted

i need to do exactly this
thank yo a lot
cant do manually are a tons of records, is a engenniering tubbing rule for modeling
thanks
0
 
AkenathonCommented:
OK, so you need to program that "engenniering tubbing rule for modeling" in a way that the computer can LEARN how to produce those numbers without your listing them one by one.

I'm not saying anything new... in maths lessons it is taught that you either define a set by listing each of its elements, or else by giving a rule that determines which elements belong to the set and which ones do not.

If you don't want to MANUALLY produce the exhaustive listing, try to import the listing from any other digital media you have... wikipedia, engineering tubing modeling manuals, etc. You do NOT have to write the numbers yourself, but you NEED to feed them into a table... how is the computer supposed to generate those numbers otherwise?
0
 
ErnestoAuthor Commented:
ok sr
im going to figured out , and im inform the avance
thank you a lot
0
 
ErnestoAuthor Commented:
come on help me here!!
0
 
ErnestoAuthor Commented:
thank yoou , sorry i can´t put it before
0
 
ErnestoAuthor Commented:
hello, help me here please
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.