An example of a non-deterministic function would be one that reads the current time or fetches ... CREATE FUNCTION dbo.discount_price(@price ... SELECT: SQL query with single/multiple variable ...