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

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[VGT04_CONTATTIUPD]
AS 
	SELECT 
		*	
	FROM GT11_CONTATTI
	WHERE GT11_SYNCGE = 1
	  AND NOT GT11_IDGE IS NULL


GO


