spProfessionCodes

        CREATE PROCEDURE dbo.spProfessionCodes
        AS
                select ID,Code,Profession
                from ProfessionCodes
                order by profession

            RETURN