I wanna calculate ratio in 3:2 form and to store its flag value and result ina database.and i have 2 textboxes wherein we enter ratio i.e.,3:2.
Now how to calculate (Tot_share/3)*2 and also if the result contain decimal value then flag value should be 'Y' Otherwise 'N'.
Here in the example we have (Tot_share/3)*2=(300/3)*2=100*2=200 since it doesnt contain decimal its flag value is Y and these values should be stored in a database table when i click the submit button.
Tot_share Result FlagValue
300 200 N
how to write stored procedure for this??
Any help would be appreciated..