USP_ALLDESIGNATIONS

                CREATE PROCEDURE USP_ALLDESIGNATIONS 
        AS
        BEGIN
              --one call for everything

            select IDMAP.ID as 'MapID', D.ID, D.DESIGNATIONLEVEL1ID, D.DESIGNATIONLEVEL2ID, D.DESIGNATIONLEVEL3ID, D.DESIGNATIONLEVEL4ID, D.DESIGNATIONLEVEL5ID, D.ISACTIVE, D.VANITYNAME, D.USERID 
            from
            dbo.DESIGNATION D
            inner join BBNCDESIGNATIONIDMAP IDMAP on IDMAP.DESIGNATIONID = D.ID
            order by D.VANITYNAME 
        END