In SQL Server, a function that returns a single ... for scalar functions cannot be overstated. Consider this simple function: CREATE FUNCTION dbo.discount_price(@price DECIMAL(12,2), @discount ...