Solved
"lookup tables" in SQL
Posted on 2011-03-07
Hi
I need some advice on adding a certain table into an SQL/Windows client. The table looks something like this:
1 2 3 4 5 6
1<x<=2 4.0 2.0 5.0 3.4 6.7 4.7
2<x<=5 3.0 2.3 4.5 3.4 5.1 6.0
The table works in this way. Suppose the variable is y on the top of the table i.e. y = 1,2,3,4,5 or 6. If I have two values y = 3 and x = 1.3, then the table would give me the answer 5.0
My questio comes in two parts, firstly, what is the best way for me to add this type of table to an SQL database. Secondly, what would be the best way to interogate the database to get the answers for a given value of x and y?
Thanks in advance
John