O'Reilly Forums: Stored Prodedure - O'Reilly Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Stored Prodedure

#1 User is offline   Joby KJ 

  • New Member
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 16-February 11

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.



0

#2 User is offline   argienchar 

  • New Member
  • Pip
  • Group: Members
  • Posts: 7
  • Joined: 16-February 11

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

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users