Herewith, I am giving you one more example of OUTPUT parameter in Stored Procedure for calculating BSA (Body Surface Area). You are in development of medical software than BSA is not a new term for you. If your body surface are is between 1 to 2 than it is normal as per my little knowledge about BSA. I am giving a sample example which will calculate BSA based on the given height and weight. Height and Weight should be either in kg (weight) and cm (height) or in lbs (weight) and inch (height). You can make it more customize by giving more dynamic conversions.
–CREATING stored procedure to return BSA (Body Surface Area)
–The calculation is from the formula of DuBois and DuBois:
–BSA = (W 0.425 x H 0.725) x 0.007184
–where the weight is in kilograms and the height is in centimeters.
–DuBois D, DuBois EF. A formula to estimate the approximate surface area
–if height and weight be known. Arch Intern Medicine. 1916; 17:863-71.
–Wang Y, Moss J, Thisted R. Predictors of body surface area.
CREATE PROC CalcBSA
@bsa FLOAT OUTPUT
SET NOCOUNT ON
–if weight and height are in kg and cm accordingly
–if weight and height are in lbs and inch accordigly
–once you done with creating stored procedure, let us see whether actually it works!!!!
DECLARE @BSA FLOAT
EXECUTE calcbsa 1,84,180,@BSA OUTPUT
If you are new to stored procedure and wants to study it than do have a look at my following basic articles. Those articles contain from basic definition of stored procedure to different usage of SP.