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