UST interview question

alternative for dynamic stored procedures?