-- =============================================
-- Author:		Marian Zaki
-- Create date: 29/11/2010
-- Description:	Checks for data validation 
-- =============================================
CREATE procedure [C6MartPeriodico].[CHECK_GET_CUSTOMERS_FOR_CHECK]
-- Add the parameters for the stored procedure here
AS
BEGIN
SELECT  distinct  [Rete]   ,[Cod_Fiscale]      
FROM C6MartPeriodico.PATRIMONIO_BF
--where cod_fiscale in (select cod_fiscale from c6mart.contrattosei where cod_Esito=1)
--And [Cod_Fiscale] <> 'DNTTMS48E03F205P'
Where  [Cod_Fiscale] <>'CVLGRL50A23C469M'
--AND   [Cod_Fiscale] = 'LBRRMN81R48L388B'
--AND  [Cod_Fiscale] IN ('BAASFN72B19E472H' ,'BAEMJA43E70Z133C')
--Select distinct   [Rete] , [Cod_Fiscale] FROM C6MartPeriodico.PATRIMONIO_BF
--where [Cod_Fiscale] <> 'DNTTMS48E03F205P'
END