USP_DESIGNATIONLEVELPROFILEREPORT_HIERARCHIES

            create proc dbo.USP_DESIGNATIONLEVELPROFILEREPORT_HIERARCHIES (@DESIGNATIONLEVELID uniqueidentifier)
            as
                select 
                    D.NAME as DESIGNATIONNAME,
                    'Report code 1' as DESIGNATIONREPORTCODE1NAME,
                    DRC.DESCRIPTION as DESIGNATIONREPORTCODE
                from 
                    dbo.DESIGNATION D
                    left join dbo.DESIGNATIONREPORT1CODE DRC on D.DESIGNATIONREPORT1CODEID = DRC.ID
                where
          D.ISREVENUEDESIGNATION = 0 and
          (
                      D.DESIGNATIONLEVEL1ID = @DESIGNATIONLEVELID or
                      D.DESIGNATIONLEVEL2ID = @DESIGNATIONLEVELID or
                      D.DESIGNATIONLEVEL3ID = @DESIGNATIONLEVELID or
                      D.DESIGNATIONLEVEL4ID = @DESIGNATIONLEVELID or
                      D.DESIGNATIONLEVEL5ID = @DESIGNATIONLEVELID
          );