Consider this simple function: CREATE FUNCTION dbo.discount ... A scalar T-SQL UDF can be inline if all of the following conditions are true: For every T-SQL scalar UDF, the sys.sql_modules ...