I agree with what you are all saying.
We are currently debating this here as well....
it's a tradeoff...
Engineering\Coding Vs DBA state of mind and maintainability
I'm stickin to my guns here and trying to stick to SPROC usage.
Gregory A Jackson MBA, CSM