Like most databases created in the last few decades, SQL Server allows ... penalty for scalar functions cannot be overstated. Consider this simple function: CREATE FUNCTION dbo.discount_price ...