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



Home Answers Viewqa SQL look up values help needed
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Harish
look up values help needed
0 Answer(s)      3 years 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
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
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.*"%>
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 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
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
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
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
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 - 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
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
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
 

 

 

DMCA.com