Assignment 3B (Bonus) - SQL Stored Procedures and Dynamic Queries

Full Assignment documentation will be available in the submission document

This assignment demonstrates my understanding of SQL, specifically:

• Cursors and stored procedures for iterative data manipulation.
• Dynamic SQL for generating flexible, user-driven reports.
• Relational integrity using JOINs across multiple tables.

Part A: Cursors

• How to use SQL cursors to iterate through records in a controlled manner.
• Managing control flow using WHILE loops and FETCH.

Part B: Dynamic SQL

• How to build parameterized dynamic SQL queries using sp_executesql.
• Accepting flexible user input for report customization (columns and filters).

I loaded the entire dataset from Assignment 2 to add depth to the tables.

Thank you Professor for the extra assignment opportunity 🙏