SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[VWGoodSimpleLastSummary]
AS
SELECT     *
FROM         (SELECT     InvoiceDate AS LastDate, Fee AS LastFee, CustomerName AS LastSeller, GoodSysCode, row_number() OVER (partition BY goodsyscode
                        ORDER BY invoicedate DESC, invoiceserialno DESC) AS Rank
FROM         VWInvoiceDetailComplete
WHERE     ((Amani = 1) AND (Type = 2 OR
                      Type = 6)) OR
                      ((Type = 2 OR
                      Type = 6) AND (FK_DocsysCode IS NOT NULL))) t1
WHERE     rank = 1
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO