USP_BBNC_GETCAMPAIGN

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

            select
                BBNCDESIGNATIONLEVELIDMAP.ID, DESIGNATIONLEVEL.USERID as SHORTDESCRIPTION, DESIGNATIONLEVEL.NAME as LONGDESCRIPTION, DESIGNATIONLEVELCATEGORYCODE.DESCRIPTION as CATEGORY, DESIGNATION.ISACTIVE, ADDEDBY.USERNAME as ADDEDBY, CHANGEDBY.USERNAME as CHANGEDBY, DESIGNATIONLEVEL.DATEADDED, DESIGNATIONLEVEL.DATECHANGED
            from 
                dbo.DESIGNATIONLEVEL
            inner join 
                dbo.DESIGNATION on DESIGNATIONLEVEL.ID = DESIGNATION.DESIGNATIONLEVEL1ID
            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;