Larry Brister
asked on
MS SQL Server function or reference Table
If I have a list of 8 statuses...
They would have an ID and a code returned based on that id
Which has the least impact on performance
Create a scalar function that I feed in an integer of 1 - 8 and get text the code returned
Or
Create a permanent table with 8 data rows
They would have an ID and a code returned based on that id
Which has the least impact on performance
Create a scalar function that I feed in an integer of 1 - 8 and get text the code returned
Or
Create a permanent table with 8 data rows
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER