PwC interview question

SQL Stored Procedures with variable