IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[VGT02_CLIFORNEW]'))
	DROP VIEW [dbo].[VGT02_CLIFORNEW]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[VGT02_CLIFORNEW]
AS 
	SELECT 
		*	
	FROM GT02_CLIENTIFORNITORI
	WHERE GT02_SYNCGE = 1
	  AND GT02_CODICEGE IS NULL





GO


