What I am trying to accomplish is the following:
Input: product ID
Output: calculated value
Process:
Use input to look up up product information distributed across 3 tables. Do some calculations. The calculations create one final number. Return that number.
I would love to have this as a function so that I can do something like the following:
select Product.product, ufn_ship( product.product_id) AS shipnum, ....
or @xyz = ufn_ship( 1234)
Thanks for any help.
Mike