USP_ATTRIBUTEFORMEXTENSION_LOAD

CREATE procedure dbo.USP_ATTRIBUTEFORMEXTENSION_LOAD
(
  @ID uniqueidentifier
)
as
  set nocount on;

  with xmlnamespaces ('bb_appfx_commontypes' as common)
    select 
    ATTRIBUTEFORMEXTENSION.EXTENDEDDATAFORMINSTANCECATALOGID, 
    ATTRIBUTEFORMEXTENSION.EXTENSIONDATAFORMINSTANCECATALOGID,
    ATTRIBUTEFORMEXTENSION.TABCAPTION,
    coalesce(DATAFORMTEMPLATECATALOG.TEMPLATESPECXML.value('(//common:DataFormExtension/@RenderStyle)[1]', 'nvarchar(11)'), 'Tab') RENDERSTYLE
    from dbo.ATTRIBUTEFORMEXTENSION
    left join dbo.DATAFORMINSTANCECATALOG on ATTRIBUTEFORMEXTENSION.EXTENSIONDATAFORMINSTANCECATALOGID = DATAFORMINSTANCECATALOG.ID
    left join dbo.DATAFORMTEMPLATECATALOG on DATAFORMINSTANCECATALOG.DATAFORMTEMPLATECATALOGID = DATAFORMTEMPLATECATALOG.ID
  where ATTRIBUTEFORMEXTENSION.ID = @ID;