Re: SQL's JOIN syntax is no harder to learn and more precise to use
Not always possible to have all the logic in the code. Sometimes a good SP can handle the complex joins needed in a complicated query way better than any coder can do at the code level.
We have some very complex queries that could be done in the client but the performance compared to an optimized SP just plain sucked.
One place where SP's suck in their own right is versioning, or a lack thereof. Would be a nice feature to have.