Planning On Going With Dynamic SQL, But...

I've read a few posts on the stored procedure vs dynamic sql debate. I ran a few performance test for myself and it appears to be a wash.



Given that, I'm leaning toward dynamic sql mostly because it would mean one fewer place to have things.



But, before we go that route we wanted to ask the question:



Is there any compelling reason why we shouldn't abandon all of our stored procs and just write the SQL inside inside our functions in our business layer (essentially our data access layer)?



Or, is it just preference these days?



I was leaning toward procs, but I have to admit it would be nice not to have to keep up with all of them per all of our functions that call them.



Thanks,
Ron