We help IT Professionals succeed at work.
Get Started
SQL Table
Hi, I need to create a SQL Table "Employees" table with the following fields:
ID, Name, Hiredate, Seniority
123, Johm, 11/8/1984, ????
For the Seniority field: if the current date - hiredate < 1 then 'Newbie'
**************************
My question is, should I put the seniority field as a calculation field? Or should I use the trigger to determine the employee is 'Newbie', 'Junior', or 'Senior'?
I have no clue how to either use the calculation to calculate the Seniority or use the trigger to do that.. Please help...
ID, Name, Hiredate, Seniority
123, Johm, 11/8/1984, ????
For the Seniority field: if the current date - hiredate < 1 then 'Newbie'
**************************
My question is, should I put the seniority field as a calculation field? Or should I use the trigger to determine the employee is 'Newbie', 'Junior', or 'Senior'?
I have no clue how to either use the calculation to calculate the Seniority or use the trigger to do that.. Please help...
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE