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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.