Please use the ERD I have provided below, The tables i circled are the ones that you
Question:
Please use the ERD I have provided below, The tables i circled are the ones that you will have to use for this sql problem.
1. Write the SQL to INSERT a new row into tblSTAFF_POSITION, using three nested "getid" stored procedures and one main stored procedure that executes the other three. Pass the following input values: the staff member's first and last name, the staff member's birthdate, the name of the position, the department the position is in, and a begin and end date. To fetch foreign keys in your nested "getid" stored procedures, use real values from tblSTAFF and tblPOSITION, and tblDEPARTMENT for the staff member's name and birthdate, the position, and the department. You can choose any begin and end date. No TRY and CATCH error-handling required, but use an explicit transactions in the main stored procedure. Write a SELECT statement to confirm that your INSERT worked.
Probability and Statistics
ISBN: 978-0321500465
4th edition
Authors: Morris H. DeGroot, Mark J. Schervish