Database Design and complex SQL queries?

[yosiasz]

This has previously been answered for you here. I am not sure what this question you are now asking about is

SQL codes VS Store procedures

Hello, Can SQL codes answer all your questions or in some cases you need store procedure no matter what. I sometimes find that SQL codes can’t always do what you need because the SQL codes can be very complex with the date changes and when calculating for a long range of period. In this case I think the answer from the database base on its design needs programming or store procedure. Do you agree.