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