Listing 2: Query That Creates Sample UDF [goes with Tip1]
ALTER CREATE FUNCTION GetTotalAmount(@OrderId int)
RETURN  money
AS
BEGIN
DECLARE @TotalAmount money

SELECT @TotalAmount = SUM(UnitPrice * Quantity)
FROM 	[Order Details] (index =0)
WHERE  OrderId = @OrderId

RETURN  @TotalAmount
END