USP_DATALIST_SECUREDCHILDQUERYVIEW

                CREATE procedure dbo.USP_DATALIST_SECUREDCHILDQUERYVIEW
                as
                    set nocount on;                    

                    select 
                        V_INSTALLED_QUERYVIEWCATALOG.ID,
                        V_INSTALLED_QUERYVIEWCATALOG.DISPLAYNAME,
                        coalesce(RECORDTYPE.NAME, '') as RECORDTYPENAME,
                        case when SECUREDCHILDQUERYVIEW.ID is null then 0 else 1 end as SECURITYENABLED
                    from
                        dbo.V_INSTALLED_QUERYVIEWCATALOG
                        left outer join dbo.SECUREDCHILDQUERYVIEW on SECUREDCHILDQUERYVIEW.ID = V_INSTALLED_QUERYVIEWCATALOG.ID
                        left outer join dbo.RECORDTYPE on V_INSTALLED_QUERYVIEWCATALOG.RECORDTYPEID = RECORDTYPE.ID
                    where
                        V_INSTALLED_QUERYVIEWCATALOG.ENFORCERECORDACCESSSECURITY = 1
                    order by
                        V_INSTALLED_QUERYVIEWCATALOG.DISPLAYNAME;