Ernesto
asked on
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
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
ASKER
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
thank you a lot
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
any idea to do so??
thank you a lot
thank you a lot
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...
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...
ASKER
no , create the table no
do the dispersion1!!
do the dispersion1!!
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!
ASKER
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
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
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?
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?
ASKER
ok sr
im going to figured out , and im inform the avance
thank you a lot
im going to figured out , and im inform the avance
thank you a lot
ASKER
come on help me here!!
ASKER
thank yoou , sorry i can´t put it before
ASKER
hello, help me here please
select * from main_values mv join disperse_values dv on mv.de = dv.de
where codigo = 'BBCDA0FE'