Jump to content


Photo

Stored Prodedure


  • Please log in to reply
1 reply to this topic

#1 Joby KJ

Joby KJ

    New Member

  • Members
  • Pip
  • 1 posts

Posted 16 February 2011 - 10:11 PM

Hi,
I need to write a stored procedure. Here is the scenario. I have a table with field name "value". This filed contains values in foramt - " height:1.60,weight:67 ". and so on.

I have to select the name of students , whose body mass index is less than 20 .

BMI = weight/height*height.




#2 argienchar

argienchar

    New Member

  • Members
  • Pip
  • 7 posts

Posted 03 March 2011 - 05:42 AM

QUOTE (Joby KJ @ Feb 16 2011, 10:11 PM) <{POST_SNAPBACK}>
I have a table with field name "value". This filed contains values in foramt - " height:1.60,weight:67 ". and so on.
I have to select the name of students , whose body mass index is less than 20 .
BMI = weight/height*height.


What is the data type of your column??




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users