>I need to create a Scalar-valued Function that returns a calculate value based on 24 different fields. Is it a bad practice to develop the function to accept 24 parameters? The fields all lie in the same table - should I pass in the PK of the record and retrieve the needed data in the function? Any other ideas?
>
Hi Mike,
I don't see anything wrong with 24 parameters by itself. If you want it make it generic and use in other places than pass 24 parameters. OTOH, if it's specialized UDF for calculation on that record only, than you can pass just PK.
--sb--