>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?
>
>Thanks!
Mike,
Yes, I think it's better to have function with just few parameters unlike stored procedures. I would just pass ID of the record.
If it's not broken, fix it until it is.
My Blog