USP_BBNC_GETDESIGNATIONLEVEL

            CREATE procedure dbo.USP_BBNC_GETDESIGNATIONLEVEL(@BBNCID int)
            as
            set nocount on;

            select
                BBNCDESIGNATIONLEVELIDMAP.ID, DESIGNATIONLEVEL.USERID as SHORTDESCRIPTION, DESIGNATIONLEVEL.NAME as LONGDESCRIPTION, DESIGNATIONLEVELCATEGORYCODE.DESCRIPTION as CATEGORY, 1 as ISACTIVE, ADDEDBY.USERNAME as ADDEDBY, CHANGEDBY.USERNAME as CHANGEDBY, DESIGNATIONLEVEL.DATEADDED, DESIGNATIONLEVEL.DATECHANGED
            from 
                dbo.DESIGNATIONLEVEL
            inner join
                dbo.BBNCDESIGNATIONLEVELIDMAP on DESIGNATIONLEVEL.ID = BBNCDESIGNATIONLEVELIDMAP.DESIGNATIONLEVELID
            inner join 
                dbo.CHANGEAGENT as ADDEDBY on ADDEDBY.ID = DESIGNATIONLEVEL.ADDEDBYID
            inner join 
                dbo.CHANGEAGENT as CHANGEDBY on CHANGEDBY.ID = DESIGNATIONLEVEL.CHANGEDBYID
            left join
                dbo.DESIGNATIONLEVELCATEGORYCODE on DESIGNATIONLEVEL.DESIGNATIONLEVELCATEGORYCODEID = DESIGNATIONLEVELCATEGORYCODE.ID
            where 
                BBNCDESIGNATIONLEVELIDMAP.ID = @BBNCID;