| Author |
Topic |
|
Mani1012
Starting Member
7 Posts |
 Posted - 2011-01-09 : 12:56:02
|
I Have Number Table Like Belowe
Temper 21 23 24 25 26 27
62 17.3 18.3 19.3 20.3 21.3 22.3
64 18.3 19.3 20.3 21.3 22.3 23.3
65 19.3 20.3 21.3 22.3 23.3 24.3
66 20.3 21.3 22.3 23.3 24.3 25.3
I Need result of 21.3 from the Table. Please Help Me! for that Qery.
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-09 : 13:04:04
|
wats the basis for getting 21.3? can you explain?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-09 : 13:04:16
|
Why is 21.3 the answer? What's the logic involved?
Also can you post the definition of the table, with data types?
--
Gail Shaw
SQL Server MVP |
|
|
|
Mani1012
Starting Member
7 Posts |
Posted - 2011-01-09 : 13:08:49
|
quote:
Originally posted by visakh16
wats the basis for getting 21.3? can you explain?
The Query is
"SELECT TempFahrenheit ='" + TxtTemperature.Text + "' FROM RichmondsFormula WHERE '" + TxtLR.Text + "'";
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-09 : 13:12:09
|
so? there are other values also in field? why 21.3?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Mani1012
Starting Member
7 Posts |
Posted - 2011-01-09 : 13:16:48
|
quote:
Originally posted by GilaMonster
Why is 21.3 the answer? What's the logic involved?
Also can you post the definition of the table, with data types?
21 23 24 25 26 27 are colum Name
62 63 64 65 66 67 are Row Name
when I Entered The 64 are Temperature through textbox. I Will Get The Value 21.3...
--
Gail Shaw
SQL Server MVP
|
|
|
|
Mani1012
Starting Member
7 Posts |
Posted - 2011-01-09 : 13:33:01
|
quote:
Originally posted by GilaMonster
Why is 21.3 the answer? What's the logic involved?
Also can you post the definition of the table, with data types?
"SELECT TempFahrenheit ='" + TxtTemperature.Text + "' FROM RichmondsFormula WHERE '" + TxtLR.Text + "'";
--
Gail Shaw
SQL Server MVP
|
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-09 : 14:08:57
|
"SELECT TempFahrenheit ='" + TxtTemperature.Text + "' FROM RichmondsFormula WHERE '" + TxtLR.Text + "'";
What is the table STRUCTURE of table RichmonsFormula, and WHY is 21.3 the "right" answer in the row. What business logic requires the answer to be 21.3?
If you enter 64 in TxtTemperature.text, what do you enter in TxtLR.Text ?
Poor planning on your part does not constitute an emergency on my part.
|
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-09 : 14:08:57
|
That's not a table definition. That's a query.
What does the table look like? What columns does it have? What data types are they? (Post the create table statement)
I still don't understand where 21.3 comes from. What's the formula to calculate it?
--
Gail Shaw
SQL Server MVP |
|
|
|
|
Queries