Queries - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

Queries

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources