SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[VWGoodSimpleLastSummary]
AS
SELECT     derivedtbl_1.GoodSysCode, dbo.VWInvoiceDetailComplete.Fee AS LastFee, dbo.VWInvoiceDetailComplete.InvoiceDate AS LastDate, 
                      CASE WHEN NOT FK_AccountSysCode IS NULL THEN Title ELSE customername END AS LastSeller
FROM         dbo.VWInvoiceDetailComplete INNER JOIN
                          (SELECT     GoodSysCode, MAX(SysCode) AS LastSysCode
                             FROM         dbo.VWInvoiceDetailComplete AS VWInvoiceDetailComplete_1
                             WHERE     (Type = 2)
                             GROUP BY GoodSysCode) AS derivedtbl_1 ON dbo.VWInvoiceDetailComplete.SysCode = derivedtbl_1.LastSysCode LEFT OUTER JOIN
                      dbo.CodeMNGUPTbl ON dbo.VWInvoiceDetailComplete.FK_AccountSysCode = dbo.CodeMNGUPTbl.AccountSysCode0
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO