A developer wanted to keep track of some birthdays with the following table design and data.
To sort the data by name and by date, the developer wrote a single stored procedure to handle both cases.
The developer tested the proc by passing a value of 1, and was pleased to see a resultset ordered by birth date.
What can go wrong? (Hint: Try passing a 2).
How could the developer fix the problem by changing only 1 line?