set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create FUNCTION [dbo].[FunGoodLastFee](@Code int) RETURNS money AS BEGIN Declare @R money SELECT TOP (1) @R= Fee FROM VWInvoiceDetailComplete WHERE (GoodSysCode = @code) AND (Amani = 1) AND (Type = 2) OR (GoodSysCode = @code) AND (NOT (FK_DocsysCode IS NULL)) AND (Type = 2) ORDER BY SysCode DESC RETURN @R END