/****** Object:  View [dbo].[V_SDD_DocumentosComReferencias]    Script Date: 24-02-2020 12:07:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[V_SDD_DocumentosComReferencias] AS
Select  c.id,
        CASE WHEN (select count(*) from dbo.TDU_ReferenciasGeradasMB as trgm with (nolock) where trgm.CDU_IDDoc=c.Id) > 0
        THEN
        1
        ELSE
        0
        END as 'ComReferenciasMB'
        from
            CabecDoc c with (nolock)
GO