Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL look up values help needed

Have Programming Question? Ask it here!
 
 
 


Harish
look up values help needed
0 Answer(s)      2 years and 8 months ago
Posted in : SQL


Hi,

I have a table that returns rows with a total weight (say 212.5 for example). I have another look up table that has range of weights with a corresponding dollar value

The look up table looks like this: (example)

kg     value
0       2.00000000000000000000
160.5   2.35000000000000000000
195.5   2.55000000000000000000
220.5   2.75000000000000000000
245.5   2.83000000000000000000
270.5   2.89000000000000000000
295.5   2.92000000000000000000
320.5   2.95000000000000000000
345.5   3.00000000000000000000
445.5   2.35000000000000000000

so in my case, (212.5kgs) I need to return the value of 2.55 as 212.5kgs is between 195.5 and 220.5

can anyone help how I can do this please?

Kind regards Harry


Advertisement
View Answers

Related Tutorials/Questions & Answers:
look up values help needed
look up values help needed  Hi, I have a table that returns rows with a total weight (say 212.5 for example). I have another look up table that has range of weights with a corresponding dollar value The look up table looks like
look up tables in java
look up tables in java  cachetables , how to apply cache mecanisam in java , i have some tables which is frequently used so i want to fetch first time and want to keep in some scope untill the application end . with out hitting
Advertisements
Help needed in JSP
Help needed in JSP  Hi .. I want to Update the multiple values of database using checkboxes and want to set the session for selected checkboxes..? please answer if any one knows as soon as possible
help Needed with requirements
help Needed with requirements  Following are my requirements : * Maintain a student database *Based on a student's test results ,reports should be generated so as to project details such as a students weakness in a particular
Java help needed
Java help needed  Create a web application that will allow a user... as needed by the number of characters of the chosen word. 2. Add 4 buttons or menu options: One for accessing help using the program, one for adding new words, one
urgent help needed!!!!
how to access values selected from connected comboboxes  how to access values selected from connected comboboxes for storing in database...i'm... access country and state....please help me.... 1)state.jsp: <%@page import
urgent help needed!!!!
comboboxes for storing in database  how to access values selected from connected comboboxes for storing in database...i'm attatching a code i got.......please help me.... 1)state.jsp: <%@page import="java.sql.*"%>
EJB JNDI LOOK UP PROBLEM - EJB
EJB JNDI LOOK UP PROBLEM  Hi, I am using jboss4.2 and created a sessionbean using EJB3 but while running client code I am finding NoInitialContextException claname not set in enviornment properties
Code Help Needed
Code Help Needed  I am trying to help a buddy of mine with this program and I can't seem to figure it out. I am still working on it but any help...[test]); line. Again thank you for any help. import java.util.*; import
help needed for a program - Java Beginners
help needed for a program   i am having trouble understanding on what to code, so can some 1 help me out here. thanks in advance. Part I Write, compile and execute a Java program that displays the following prompts
help needed - Java Interview Questions
help needed  What are the new features added in jdk 1.5?  Hi friend, The following were the new features added in java 1.5.... * Autoboxing/unboxing ------------------------- This link will help you
Help needed for Form Validation please help!
Help needed for Form Validation please help!  I have created a page.../password combination . Problem arises while validating the Sign up part as after clicking the submit button for sign up it also goes through the jsp code and returns
servlet redirect problem help needed
servlet redirect problem help needed  package p; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import
servlet redirect problem help needed
servlet redirect problem help needed  package p; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import
PHP help needed - Development process
PHP help needed  This is my code that I am using for search engine, can any body answer how to cheange the code if I want limited and per page result display??? code Career Search result Yami says <?php
Help needed for J2me and PHP - Development process
Help needed for J2me and PHP  Hello Sir I am a degree student. I have a small CRM application using J2me and PHP. I want to do cryptography using... but could not get result. I will appreciate your help. Regards
urgent help needed in JDBC AND JAVA GUI - JDBC
urgent help needed in JDBC AND JAVA GUI  my application allows... want any one to help me convert from scanner to java GUI for this code...(); } } // thanks for any help rendered   Hi Friend, Try the following code
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP   The Task Write a class whose objects will represent students... and exam marks (add them up and divide by two) are greater than
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP   Write a class whose objects will represent students.The class should have three...? depending on whether or not the combined coursework and exam marks (add them up
Help needed on java standalone app and default browser interaction.
Help needed on java standalone app and default browser interaction.  Hi Developers and tutors, Is anyone able to guide on how am i able to extract...? Platform Windows Browser IE7 Any from of help would be deeply apperciated
Navigate database values using up and down key of keyboard
Navigate database values using up and down key of keyboard In this section, you will learn how to navigate database values using up and down keys... the database values. On pressing the up key, the following code will fetch one by one
please help me how to set up Netbeans for JSP
please help me how to set up Netbeans for JSP   Hi roseindian.net... help me.We are ready to do INDUSTRIAL PROJECT by JSP. Thank you. ERROR.../xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Encoding: gzip,deflate,sdch
Setting up Database with the help of PHP Scripts.
PHP Database Set Up Script Part-5(c) : Setting up the database 2. Database Creation with the help of PHP Scripts. With the help of PHP Scripts, we can also... in the last tutorial that MySQL has its own standard set up to create database which
Packages needed for JDBC in Linux
Packages needed for JDBC in Linux  Can anyone tell me the packages needed to run a program with JDBC in Red Hat 5
A program solution needed
A program solution needed   I need a solve for this problem please ! a program that displays grade statistics. The program should read any number of grades (up to 100) and ends when the user enters -1, the program should reject
Look and Feel - Swing AWT
Look and Feel  i m using netbeans for creating a swing GUI...... and i want to know how to give my gui the "Windows look" as by default it is set to "metal Look".  Hi Friend, Please visit the following links
Look and Feel
-platform Look & Feel. There are several good reasons to change it however.... The javax.swing.UIManager class methods can be used to set it. To Set the Look... practice. What else can we do in this case? // The default look & feel
look and feel - Framework
look and feel  Hi, i created one jsf page with images and commandlinks ,i adjusted all the spaces in my system here it is looking good but in other sysem it is not looking good.I need solution for the page looking good in any
Needed jsp codes
Needed jsp codes   jsp code for employee payroll.producing a payslip of every employees monthly calculating the gross pay of a particular employee considering the income tax and producing a report which can be printed out
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap   i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap   i want to create invoice report .. help out asap
I want to update the multiple values of database depending on checkbox..? Please help me out..
I want to update the multiple values of database depending on checkbox..? Please help me out..   Hi .. I want to Update the multiple values of database using checkboxes and want to set the session for selected checkboxes
JavaScript Pop Up Boxes
JavaScript Pop Up Boxes JavaScript has three kind of pop-up boxes,  i)    Alert-Box: If some surety is required from the user or an alert message is to generate then we can use alert box, user has to click ok
pop up
pop up  how to create pop up in html
Can anybody help how to store values to the following xml from .NET application
Can anybody help how to store values to the following xml from .NET application  Can anybody help how to store values to the following xml from .NET application <SQLSchema> <Databases>
Needed modifications to ApplicationContext if extending this application
Needed modifications to ApplicationContext if extending this application   I followed the Developing Struts Hibernate and Spring Based Login/Registration Application tutorial and that is very good. Now I need to modify
Needed modifications to ApplicationContext if extending this application
Needed modifications to ApplicationContext if extending this application   I followed the Developing Struts Hibernate and Spring Based Login/Registration Application tutorial and that is very good. Now I need to modify
Help...
Help...  Write a class that displays your first name vertically down the screen ?? where each letter uses up to 5 rows by 5 columns of a character input by you with a blank line between each letter
Limiting the Values in a Number JSpinner Component
will learn how to create a Number JSpinner that can take values up to certain maximum... Limiting the Values in a Number JSpinner Component... up to certain maximum limit. Following program has used some methods and APIs
Pop Up window - WebSevices
Pop Up window  How refresh pop up window,Tell me correct code for this problem.  Hi friend, I am sending a link. This link will help you. Visit for more information. http://www.roseindia.net/jsp/popup-window
Changing Look and Feel of Swing Application
Changing Look and Feel of Swing Application       This section shows how to set different look and feel for your Swing Application. The look and feel feature of Java Swing
Showing the Frame with Default Look and Feel
Showing the Frame with Default Look and Feel   ... the frame in the default look and feel. Displayed frame has a combo box and a text... shot of frame with default look and feel: Here is the code of the program
help
display all the computed values in the previous assignments in a text area. ... proper screen layout models. Your frames should look clear and display all... based on the percentage of cheating. please help me
what programs are needed in java programming? - Java Beginners
what programs are needed in java programming?  What programs are needed in java programming?   Hi friend, For solving the problem visit to : http://www.roseindia.net/java/] Thanks  Hi friend
easy way to make a JCombobox look like a JTextField?
easy way to make a JCombobox look like a JTextField?  Is there a good(and easy) way to make a JCombobox look like a JTextField? By this I mean there should not be a dropdown button, but when the user enters something it should
pop up message in java
pop up message in java  hii..i have developed an application in which a login and registration form is there.when the registration is done the user... swings. please help..its urgent
pop up window in java
pop up window in java  How to open a pop up window in Java
help
help   how i can send a pitcture on url in java
POP UP WINDOW
POP UP WINDOW  Dear Sir, Can you please help in providing the methos for opening up a pop up window just after selecting an option from a drop...',then a pop up window should open with name,designation and roll number.Please help me
Can u Look to the error plz - Java Beginners
Can u Look to the error plz  this is my code can u modify it plz and give me the result of it when u check it on eclipse or jcreator plz and i...;where is the answer sir.? just i want from you to look what is the error plz
Advertisements
 

 

 

DMCA.com