USP_ATTRIBUTECATEGORY_GETINFORMATIONBYID

CREATE procedure dbo.USP_ATTRIBUTECATEGORY_GETINFORMATIONBYID
(
    @ID as uniqueidentifier
)
as
    select
        ATTRIBUTECATEGORY.ID as ATTRIBUTECATEGORYID,
        ATTRIBUTECATEGORY.DATATYPECODE,
        ATTRIBUTECATEGORY.NAME as CATEGORYNAME,
        ATTRIBUTECATEGORY.ONLYALLOWONEPERRECORD as ONEPERRECORD,
        coalesce(CODETABLECATALOG.DBTABLENAME,'') as CODETABLEDBNAME,
        TABLECATALOG.TABLENAME as ATTRIBUTETABLENAME,
        RECORDTABLECATALOG.TABLENAME as RECORDTABLENAME,
        ATTRIBUTECATEGORY.VALUECOLUMNNAME,
        ATTRIBUTECATEGORY.CONSTITUENTSEARCHLISTCATALOGID,
        ATTRIBUTEGROUPCODE.ID as ATTRIBUTEGROUPCODEID,
        isnull(ATTRIBUTEGROUPCODE.DESCRIPTION,'') as ATTRIBUTEGROUP,
        RECORDTYPE.NAME as RECORDTYPE 
  from
        dbo.ATTRIBUTECATEGORY                    
        inner join dbo.ATTRIBUTERECORDTYPE on ATTRIBUTERECORDTYPE.ID = ATTRIBUTECATEGORY.ATTRIBUTERECORDTYPEID
        inner join dbo.RECORDTYPE on RECORDTYPE.ID = ATTRIBUTERECORDTYPE.RECORDTYPEID
        inner join dbo.TABLECATALOG on TABLECATALOG.ID = ATTRIBUTECATEGORY.TABLECATALOGID 
        inner join dbo.TABLECATALOG as RECORDTABLECATALOG on RECORDTABLECATALOG.ID = ATTRIBUTECATEGORY.ATTRIBUTERECORDTYPEID
        left join dbo.CODETABLECATALOG on CODETABLECATALOG.ID = ATTRIBUTECATEGORY.CODETABLECATALOGID  
        left join dbo.ATTRIBUTEGROUPCODE on ATTRIBUTEGROUPCODE.ID = ATTRIBUTECATEGORY.ATTRIBUTEGROUPCODEID
    where
        ATTRIBUTECATEGORY.ID = @ID
    order by
        ATTRIBUTECATEGORY.NAME;