UFN_QUERYVIEW_GETMETADATA_BYOBJECTNAMEXML

create function dbo.UFN_QUERYVIEW_GETMETADATA_BYOBJECTNAMEXML
  (
    @OBJECTNAMEXML XML
  )
  returns table
    as
    return
    (
                select 
            QUERYVIEWCATALOG.ID, 
                    QUERYVIEWCATALOG.OBJECTNAME, 
                    QUERYVIEWCATALOG.DISPLAYNAME, 
                    QUERYVIEWCATALOG.RECORDTYPEID, 
                    RECORDTYPE.NAME as [RECORDTYPE],
                    QUERYVIEWCATALOG.OBJECTTYPE, 
                    QUERYVIEWCATALOG.ROOTOBJECT, 
                    QUERYVIEWCATALOG.SUBGROUP, 
                    QUERYVIEWCATALOG.OUTPUTDEFINITIONXML, 
                    QUERYVIEWCATALOG.PARAMETERMETADATAXML,
                    QUERYVIEWCATALOG.QUERYVIEWSPEC,
                    QUERYVIEWCATALOG.QUERYVIEWSPECEXTENSION,
                    (select count(*) from dbo.QUERYVIEWRELATIONSHIP where ROOTQUERYVIEWID = QUERYVIEWCATALOG.ID) CHILDNODECOUNT,
                    QUERYVIEWCATALOG.TSLONG
              from dbo.QUERYVIEWCATALOG
        inner join @OBJECTNAMEXML.nodes('QueryViews/QueryView') As Q(c) on Q.c.value('./@ObjectName', 'nvarchar(250)') = QUERYVIEWCATALOG.OBJECTNAME
              left join dbo.RECORDTYPE on QUERYVIEWCATALOG.RECORDTYPEID = RECORDTYPE.ID
    )