Sollicitatievraag bij American Express

When does one use stored procedure vs Dynamic SQL while working with RDBMS?