Suppose you have a web application where based on some numbers the user has entered you give him another number (over simplified) when he/she clicks a button. All the data is stored in SQL server. Now I can get all the required data to the Business access layer and do the calculation there. Or do the calculation in the database stored proc and send the result to the application. I strongly prefer the latter,because I find it much easier. But some people may argue all the business logic must lie in business layer in the app. I feel if there is any business logic in the app, it belongs in business layer. But you don't have to have the data related business logic in the app.

What would the experts recommend?