Solution to Activity 10.5

In this activity, you will create a stored procedure to determine dates, generate a passthrough query, and assign it to both date dropdowns. Follow the following steps to implement it:

1. Create a new SQL file and name it Create Procedure spDateRange_par.sql to generate a stored procedure.
2. Open the file named spCountryList_par.sql and copy and paste all of its code into the new file. You will modify this code.
3. Continuing in the new file, spDateRange_par.sql, there are two locations where the stored procedure's name is referenced. Change these to the new name of spDateRange_par.sql. They are in the Drop Procedure and Create Procedure lines.
4. Include the parameters in the Create Procedure line. The parameters are Tablename and TheSeries. Be sure to include IN and the data type declaration for both parameters.
5. Modify the SQL statement to return the Year field and set the series filter in the WHERE clause.
6. We then need to develop SQL...