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


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[VGT03_CONTATTINEW]
AS 
	SELECT 
		*	
	FROM GT11_CONTATTI
	WHERE GT11_SYNCGE = 1
	  AND GT11_IDGE IS NULL
	  AND GT11_ID_GT02 > 0


GO


