Posted 16 February 2011 - 10:11 PM
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.