Find 40 Problems in this Stored Procedure

For my first post on Simple Talk, I rip apart a made-up stored procedure as if I had encountered it during a code review.