I was asked which method of lookup call would be the best way to follow.
Currently we only have a small amount of test data so it's even across the board.
Lookups here are for the most part STATIC and SMALL. Coders are considering putting the Lookups in code in a case statement, or writing a UDF() or doing a join.
Price Type has 4 possibilities.
Regions have 12.
If your going to bring in those 2 tables lookup descriptions for a report that is processing say 2,000 to 24,000 rows, is it beneficial to get that Text Value by :
1) Case
2) UDF()
3) Join
TIA
__Stephen