USP_ATTRIBUTECATEGORY_GETEXTENSIONDATAFORMIDS

create procedure dbo.USP_ATTRIBUTECATEGORY_GETEXTENSIONDATAFORMIDS
(
  @ID uniqueidentifier
)
as
  set nocount on;

  declare @likeClause nvarchar(50);

  select @likeClause = '%' + TABLENAME + '%'
  from dbo.ATTRIBUTECATEGORY
  inner join dbo.TABLECATALOG on ATTRIBUTECATEGORY.TABLECATALOGID = TABLECATALOG.ID
  where ATTRIBUTECATEGORY.ID = @ID;

  with xmlnamespaces ('bb_appfx_adddataformtemplate' as addspec, 'bb_appfx_editdataformtemplate' as editspec, 'bb_appfx_viewdataformtemplate' as viewspec, 'bb_appfx_commontypes' as common)
  select ATTRIBUTEFORMEXTENSION.EXTENSIONDATAFORMINSTANCECATALOGID EXTENSIONDATAFORMID
  from dbo.ATTRIBUTEFORMEXTENSION
  inner join dbo.DATAFORMINSTANCECATALOG on ATTRIBUTEFORMEXTENSION.EXTENSIONDATAFORMINSTANCECATALOGID = DATAFORMINSTANCECATALOG.ID
  inner join dbo.DATAFORMTEMPLATECATALOG on DATAFORMINSTANCECATALOG.DATAFORMTEMPLATECATALOGID = DATAFORMTEMPLATECATALOG.ID
  where (DATAFORMTEMPLATECATALOG.MODE = 0 and DATAFORMTEMPLATECATALOG.TEMPLATESPECXML.value('(viewspec:ViewDataFormTemplateSpec/viewspec:SPDataForm/common:CreateProcedureSQL)[1]', 'nvarchar(max)') like @likeClause)
  or (DATAFORMTEMPLATECATALOG.MODE = 1 and DATAFORMTEMPLATECATALOG.TEMPLATESPECXML.value('(editspec:EditDataFormTemplateSpec/editspec:SPDataForm/editspec:LoadImplementation/common:CreateProcedureSQL)[1]', 'nvarchar(max)') like @likeClause)
  or (DATAFORMTEMPLATECATALOG.MODE = 2 and DATAFORMTEMPLATECATALOG.TEMPLATESPECXML.value('(addspec:AddDataFormTemplateSpec/addspec:SPDataForm/addspec:SaveImplementation/common:CreateProcedureSQL)[1]', 'nvarchar(max)') like @likeClause)