SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[VWGoodSimpleLastSummary]
AS
SELECT     GoodSysCode, dbo.FunGoodLastSeller(GoodSysCode) AS LastSeller, dbo.FunGoodLastFee(GoodSysCode) AS LastFee, 
                      dbo.FunGoodLastDate(GoodSysCode) AS LastDate
FROM         dbo.VWInvoiceDetailComplete
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO