Dynamic Stored procedures,whether to create in the application code behind/database?

Question

Hi friends,

I want to create a dynamic stored procedure. Whether i should create it in the databse or can i create in in my dataaccess layer, i need your guidance please