|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Querying for nearest values...How can I query a table for the nearest values (i.e. next record above and next record below) to the query parameter? For example let's say that I have a table with the following colums: Pressure - 120,115,110...50,46.4,42.8 Temperature - 0,10,20...1200,1400,1600 Value - 1,2,3...100,200,300 The 'Value' column contains the data for a specific pressure and temperature. How could I query the 'Value' column for nearest values given parameters such as: Pressure = 112.5 Temperature = 220 ??? Thank you! Are you looking for :
max(pressure) < [input pressure] min(pressure) > [input pressure] and Show quote "jd6strings" <je***@skywerx.com> wrote in message news:1143839140.061894.221700@g10g2000cwb.googlegroups.com... > Hello: > > How can I query a table for the nearest values (i.e. next record above > and next record below) to the query parameter? For example let's say > that I have a table with the following colums: > > Pressure - 120,115,110...50,46.4,42.8 > Temperature - 0,10,20...1200,1400,1600 > Value - 1,2,3...100,200,300 > > The 'Value' column contains the data for a specific pressure and > temperature. > > How could I query the 'Value' column for nearest values given > parameters such as: > > Pressure = 112.5 > Temperature = 220 > > ??? > > Thank you! > Posting DDL and a better explanation of what you need will help, along with
sample data presented as rows and columns. See below for an explanation... http://www.aspfaq.com/etiquette.asp?id=5006 Are you looking for : max(pressure) < [input pressure] min(pressure) > [input pressure] and max(Temperature) < [input Temperature] min(Temperature) > [input Temperature] or are you looking for max(Value) < [input Value] min(Value) > [input Value] where [input Value] = (select value where Temperature = [input Temperature] and pressure= [input pressure]) Show quote "jd6strings" <je***@skywerx.com> wrote in message news:1143839140.061894.221700@g10g2000cwb.googlegroups.com... > Hello: > > How can I query a table for the nearest values (i.e. next record above > and next record below) to the query parameter? For example let's say > that I have a table with the following colums: > > Pressure - 120,115,110...50,46.4,42.8 > Temperature - 0,10,20...1200,1400,1600 > Value - 1,2,3...100,200,300 > > The 'Value' column contains the data for a specific pressure and > temperature. > > How could I query the 'Value' column for nearest values given > parameters such as: > > Pressure = 112.5 > Temperature = 220 > > ??? > > Thank you! > Here's DDL:
CREATE TABLE [DewPointValues] ( [Pressure] [float] NULL , [Value] [float] NULL , [Temperature] [float] NULL ) ON [PRIMARY] GO INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,2.890000000000000e+002,3.200000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,3.340000000000000e+002,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,3.850000000000000e+002,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,4.420000000000000e+002,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,5.070000000000000e+002,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,5.800000000000000e+002,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,6.630000000000000e+002,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,7.550000000000000e+002,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,8.590000000000000e+002,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,9.750000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,9.960000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,1.183000000000000e+003,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,1.400000000000000e+003,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,1.651000000000000e+003,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,1.940000000000000e+003,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,2.273000000000000e+003,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,2.655000000000000e+003,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,3.091000000000000e+003,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,3.588000000000000e+003,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,4.153000000000000e+003,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,4.793000000000000e+003,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(0.000000000000000e+000,5.517000000000000e+003,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,1.730000000000000e+002,3.200000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,2.000000000000000e+002,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,2.300000000000000e+002,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,2.640000000000000e+002,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,3.030000000000000e+002,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,3.470000000000000e+002,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,3.960000000000000e+002,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,4.510000000000000e+002,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,5.130000000000000e+002,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,5.830000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,5.950000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,7.070000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,8.360000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,9.860000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,1.159000000000000e+003,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,1.358000000000000e+003,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,1.585000000000000e+003,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,1.845000000000000e+003,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,2.142000000000000e+003,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,2.479000000000000e+003,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,2.861000000000000e+003,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+001,3.292000000000000e+003,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,1.240000000000000e+002,3.200000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,1.430000000000000e+002,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,1.640000000000000e+002,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,1.890000000000000e+002,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,2.170000000000000e+002,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,2.480000000000000e+002,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,2.830000000000000e+002,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,3.230000000000000e+002,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,3.670000000000000e+002,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,4.160000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,4.250000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,5.050000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,5.980000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,7.050000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,8.280000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,9.700000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,1.132000000000000e+003,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,1.318000000000000e+003,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,1.530000000000000e+003,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,1.770000000000000e+003,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,2.042000000000000e+003,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+001,2.350000000000000e+003,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,9.690000000000001e+001,3.200000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.110000000000000e+002,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.280000000000000e+002,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.470000000000000e+002,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.690000000000000e+002,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.930000000000000e+002,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,2.210000000000000e+002,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,2.520000000000000e+002,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,2.860000000000000e+002,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,3.250000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,3.320000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,3.940000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,4.660000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,5.490000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,6.450000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,7.560000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,8.820000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.027000000000000e+003,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.191000000000000e+003,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.378000000000000e+003,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.590000000000000e+003,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+001,1.830000000000000e+003,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,7.970000000000000e+001,3.200000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,9.190000000000001e+001,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,1.050000000000000e+002,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,1.210000000000000e+002,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,1.390000000000000e+002,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,1.590000000000000e+002,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,1.810000000000000e+002,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,2.060000000000000e+002,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,2.350000000000000e+002,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,2.660000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,2.720000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,3.230000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,3.820000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,4.500000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,5.290000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,6.200000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,7.230000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,8.420000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,9.770000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,1.130000000000000e+003,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,1.303000000000000e+003,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+001,1.500000000000000e+003,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,6.780000000000000e+001,3.200000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,7.820000000000000e+001,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,8.990000000000001e+001,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,1.030000000000000e+002,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,1.180000000000000e+002,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,1.350000000000000e+002,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,1.540000000000000e+002,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,1.750000000000000e+002,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,1.990000000000000e+002,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,2.260000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,2.310000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,2.740000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,3.240000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,3.820000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,4.490000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,5.260000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,6.140000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,7.140000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,8.280000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,9.580000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,1.105000000000000e+003,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+001,1.271000000000000e+003,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,4.960000000000000e+001,3.200000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,5.720000000000000e+001,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,6.580000000000000e+001,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,7.550000000000000e+001,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,8.650000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,9.880000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,1.120000000000000e+002,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,1.280000000000000e+002,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,1.450000000000000e+002,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,1.650000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,1.690000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,2.000000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,2.360000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,2.780000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,3.270000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,3.830000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,4.460000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,5.190000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,6.020000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,6.960000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,8.030000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.500000000000000e+001,9.240000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,3.940000000000000e+001,3.200000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,4.530000000000000e+001,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,5.210000000000000e+001,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,5.980000000000000e+001,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,6.850000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,7.820000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,8.920000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,1.010000000000000e+002,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,1.150000000000000e+002,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,1.300000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,1.330000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,1.580000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,1.870000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,2.200000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,2.580000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,3.020000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,3.520000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,4.090000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,4.750000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,5.490000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,6.330000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+002,7.270000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,3.780000000000000e+001,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,4.340000000000000e+001,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,4.970000000000000e+001,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,5.690000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,6.500000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,7.409999999999999e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,8.430000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,9.559999999999999e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,1.080000000000000e+002,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,1.110000000000000e+002,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,1.310000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,1.550000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,1.820000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,2.140000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,2.500000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,2.910000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,3.390000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,3.930000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,4.540000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,5.230000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.250000000000000e+002,6.020000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,3.250000000000000e+001,3.560000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,3.730000000000000e+001,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,4.270000000000000e+001,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,4.890000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,5.580000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,6.360000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,7.230000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,8.200000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,9.290000000000001e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,9.480000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,1.120000000000000e+002,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,1.330000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,1.560000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,1.830000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,2.140000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,2.490000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,2.900000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,3.360000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,3.880000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,4.470000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.500000000000000e+002,5.140000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,3.280000000000000e+001,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,3.760000000000000e+001,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,4.300000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,4.900000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,5.580000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,6.340000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,7.200000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,8.150000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,8.320000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,9.850000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,1.160000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,1.370000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,1.600000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,1.870000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,2.180000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,2.540000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,2.940000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,3.390000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,3.910000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.750000000000000e+002,4.490000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,2.940000000000000e+001,3.920000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,3.360000000000000e+001,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,3.840000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,4.380000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,4.990000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,5.670000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,6.430000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,7.270000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,7.430000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,8.790000000000001e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,1.040000000000000e+002,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,1.220000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,1.430000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,1.670000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,1.940000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,2.260000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,2.620000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,3.020000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,3.480000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+002,4.000000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,3.050000000000000e+001,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,3.480000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,3.970000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,4.520000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,5.130000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,5.820000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,6.580000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,6.720000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,7.950000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,9.370000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,1.100000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,1.290000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,1.510000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,1.760000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,2.040000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,2.360000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,2.730000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,3.140000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.250000000000000e+002,3.600000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,2.790000000000000e+001,4.280000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,3.190000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,3.640000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,4.140000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,4.700000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,5.320000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,6.020000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,6.150000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,7.270000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,8.570000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,1.010000000000000e+002,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,1.180000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,1.380000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,1.600000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,1.860000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,2.150000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,2.490000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,2.860000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.500000000000000e+002,3.290000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,2.950000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,3.360000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,3.820000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,4.340000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,4.910000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,5.560000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,5.670000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,6.709999999999999e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,7.900000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,9.280000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,1.090000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,1.270000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,1.480000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,1.710000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,1.980000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,2.290000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,2.630000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.750000000000000e+002,3.020000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,2.750000000000000e+001,4.640000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,3.130000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,3.560000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,4.040000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,4.570000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,5.170000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,5.270000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,6.230000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,7.340000000000001e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,8.620000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,1.010000000000000e+002,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,1.180000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,1.370000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,1.590000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,1.840000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,2.120000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,2.440000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+002,2.800000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,2.760000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,3.130000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,3.550000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,4.020000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,4.550000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,4.640000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,5.480000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,6.450000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,7.570000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,8.850000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,1.030000000000000e+002,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,1.200000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,1.390000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,1.610000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,1.860000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,2.140000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.500000000000000e+002,2.450000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,2.480000000000000e+001,5.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,2.810000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,3.190000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,3.610000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,4.080000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,4.160000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,4.910000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,5.770000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,6.770000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,7.920000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,9.230000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,1.070000000000000e+002,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,1.240000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,1.440000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,1.660000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,1.900000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.000000000000000e+002,2.180000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,2.560000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,2.900000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,3.280000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,3.710000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,3.780000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,4.460000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,5.240000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,6.150000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,7.180000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,8.359999999999999e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,9.720000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,1.130000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,1.300000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,1.500000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,1.720000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(4.500000000000000e+002,1.970000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,2.360000000000000e+001,5.360000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,2.670000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,3.020000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,3.410000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,3.480000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,4.100000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,4.820000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,5.640000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,6.590000000000001e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,7.670000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,8.900000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,1.030000000000000e+002,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,1.190000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,1.370000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,1.580000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(5.000000000000000e+002,1.800000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,2.320000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,2.620000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,3.330000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,3.020000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,3.550000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,4.170000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,4.880000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,5.690000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,6.620000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,7.680000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,8.880000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,1.020000000000000e+002,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,1.180000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,1.350000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(6.000000000000000e+002,1.550000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,2.070000000000000e+001,5.720000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,2.340000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,2.630000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,2.690000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,3.160000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,3.710000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,4.330000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,5.050000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,5.860000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,6.790000000000001e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,7.850000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,9.050000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,1.040000000000000e+002,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,1.190000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(7.000000000000000e+002,1.370000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,2.120000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,2.390000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,2.440000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,2.870000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,3.350000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,3.920000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,4.560000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,5.290000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,6.130000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,7.080000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,8.150000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,9.370000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,1.070000000000000e+002,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(8.000000000000000e+002,1.230000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,1.960000000000000e+001,6.080000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,2.200000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,2.250000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,2.630000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,3.080000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,3.590000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,4.180000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,4.850000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,5.610000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,6.470000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,7.450000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,8.550000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,9.790000000000001e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(9.000000000000000e+002,1.120000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,2.040000000000000e+001,6.440000000000001e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,2.090000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,2.450000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,2.860000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,3.330000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,3.870000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,4.490000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,5.190000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,5.980000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,6.880000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,7.900000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,9.040000000000001e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.000000000000000e+003,1.030000000000000e+002,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,1.850000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,2.170000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,2.530000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,2.940000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,3.410000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,3.950000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,4.560000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,5.250000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,6.030000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,6.909999999999999e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,7.900000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.200000000000000e+003,9.009999999999999e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,1.680000000000000e+001,6.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,1.970000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,2.290000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,2.660000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,3.080000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,3.560000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,4.110000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,4.720000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,5.420000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,6.200000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,7.080000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.400000000000000e+003,8.070000000000000e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,1.810000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,2.110000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,2.450000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,2.830000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,3.270000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,3.770000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,4.330000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,4.960000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,5.670000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,6.470000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.600000000000000e+003,7.370000000000000e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,1.700000000000000e+001,7.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,1.970000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,2.280000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,2.640000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,3.040000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,3.500000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,4.020000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,4.600000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,5.260000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,5.990000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(1.800000000000000e+003,6.809999999999999e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,1.860000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,2.150000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,2.490000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,2.860000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,3.290000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,3.770000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,4.310000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,4.920000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,5.610000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.000000000000000e+003,6.370000000000000e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,1.770000000000000e+001,7.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,2.040000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,2.360000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,2.710000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,3.120000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,3.570000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,4.080000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,4.650000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,5.290000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.200000000000000e+003,6.010000000000000e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,1.950000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,2.250000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,2.590000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,2.970000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,3.400000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,3.880000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,4.420000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,5.030000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.400000000000000e+003,5.710000000000000e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,1.880000000000000e+001,8.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,2.160000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,2.480000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,2.850000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,3.260000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,3.720000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,4.230000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,4.810000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.600000000000000e+003,5.450000000000000e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.800000000000000e+003,2.090000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.800000000000000e+003,2.390000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.800000000000000e+003,2.740000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.800000000000000e+003,3.130000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.800000000000000e+003,3.570000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.800000000000000e+003,4.070000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.800000000000000e+003,4.620000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(2.800000000000000e+003,5.230000000000000e+001,1.200000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+003,2.020000000000000e+001,8.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+003,2.320000000000000e+001,9.000000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+003,2.650000000000000e+001,9.500000000000000e+001) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+003,3.043000000000000e+001,1.000000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+003,3.450000000000000e+001,1.050000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+003,3.920000000000000e+001,1.100000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+003,4.450000000000000e+001,1.150000000000000e+002) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(3.000000000000000e+003,5.040000000000000e+001,1.200000000000000e+002) What I want is...say we have a pressure of 11.2 and a temperature of 92.3, I'd like to return the value associated with a pressure of 10 and a temp of 90, the value of a pressure of 10 and a temp of 95, the value of a pressure of 20 and a temp of 90, and the value of a pressure of 20 and a temp of 95. Does this make sense? My data does NOT have the the exact values for the possible pressure/temp parameters so I just need to get close. Thanks for your reply! What DECLARE @Pressure float
DECLARE @Temperature float SET @Pressure=11.2 SET @Temperature=92.3 SELECT Value,Pressure,Temperature FROM DewPointValues WHERE Pressure IN ((SELECT MAX(Pressure) FROM DewPointValues WHERE Pressure <= @Pressure), (SELECT MIN(Pressure) FROM DewPointValues WHERE Pressure >= @Pressure)) AND Temperature IN ((SELECT MAX(Temperature) FROM DewPointValues WHERE Temperature <= @Temperature), (SELECT MIN(Temperature) FROM DewPointValues WHERE Temperature >= @Temperature)) Beautiful! I spent 2.5 hours trying to get SQL Server to cooperate. I
was close but hadn't quite nailed it. Thank you! I can now take the average of the returned values to give me a close approximation. Thx again! At some point, Mark's solution will return no data. For example,
if you insert these additional rows, INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(11e0,5e1,99e0) INSERT INTO [DewPointValues] ([Pressure],[Value],[Temperature])VALUES(11.5e0,5e1,99e0) you won't get anything back from Mark's query. The next warmest and coldest temperatures may not appear in your data in rows that also contain the next highest or lowest pressures. You'll have to define more precisely what you mean by "nearest". If the closest temperature match has a very different pressure, and the closest pressure match has a very different temperature, what result do you want to see? Maybe there is a single row in DewPointValues that contains the third or fourth closest of each, and that is the "closest" match. There is no standard answer to a question like this. One possibility is this, but it's computationally expensive. SELECT TOP 2 Value,Pressure,Temperature FROM DewPointValues CROSS JOIN ( SELECT STDEVP(Pressure) as sdP, STDEVP(Temperature) as sdT FROM DewPointValues ) as SD ORDER BY ABS(Pressure-@Pressure)/sdP + ABS(Temperature-@Temperature)/sdT If you can set a threshold for how close either the temperature or pressure must be to see any result at all, you can exclude some values right off the bat, and efficiently if you have suitable indexes on the table. Steve Kass Drew University jd6strings wrote: Show quote >Beautiful! I spent 2.5 hours trying to get SQL Server to cooperate. I >was close but hadn't quite nailed it. Thank you! I can now take the >average of the returned values to give me a close approximation. > >Thx again! > > > jd6strings (je***@skywerx.com) writes:
Show quote > How can I query a table for the nearest values (i.e. next record above SELECT value> and next record below) to the query parameter? For example let's say > that I have a table with the following colums: > > Pressure - 120,115,110...50,46.4,42.8 > Temperature - 0,10,20...1200,1400,1600 > Value - 1,2,3...100,200,300 > > The 'Value' column contains the data for a specific pressure and > temperature. > > How could I query the 'Value' column for nearest values given > parameters such as: > > Pressure = 112.5 > Temperature = 220 FROM tbl WHERE pressure = (SELECT MAX(presussure) FROM tbl WHERE pressure <= 112.5) OR pressure = (SELECT MIN(presussure) FROM tbl WHERE pressure >= 112.5) -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics