set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create FUNCTION [dbo].[FunGoodLastSeller](@Code int) RETURNS nvarchar(1000) AS BEGIN Declare @R nvarchar(1000) SELECT TOP (1) @R= CodeMNGDWNTbl.Title FROM VWInvoiceDetailComplete INNER JOIN CodeMNGDWNTbl ON VWInvoiceDetailComplete.FK_AccountSysCode = CodeMNGDWNTbl.AccountSysCode WHERE (VWInvoiceDetailComplete.GoodSysCode = @code) AND (VWInvoiceDetailComplete.Amani = 1) AND (NOT (VWInvoiceDetailComplete.FK_AccountSysCode IS NULL)) AND (VWInvoiceDetailComplete.Type = 2) OR (VWInvoiceDetailComplete.GoodSysCode = @code) AND (NOT (VWInvoiceDetailComplete.FK_AccountSysCode IS NULL)) AND (NOT (VWInvoiceDetailComplete.FK_DocsysCode IS NULL)) AND (VWInvoiceDetailComplete.Type = 2) ORDER BY VWInvoiceDetailComplete.SysCode DESC RETURN @R END