Decipha interview question

A technical question around SQL Stored Procedures