I'm currently working on a web project which is a bit of a mess, half the calculations are done in C# and half are done in stored procedures.
For simple calculations the stored procedures are fine, however we have a lot of very complex calculations (lots of joins, exclusions, string concatenation etc) and trying to write them in a SP is tricky when I know it could be done much simpler using C#. Most of these calculation results are passed to Crystal Reports (via C# usually).
Which method ultimately would be the best? I can go either way really but it creates a lot of work no matter how I do it.
Cheers
.
For simple calculations the stored procedures are fine, however we have a lot of very complex calculations (lots of joins, exclusions, string concatenation etc) and trying to write them in a SP is tricky when I know it could be done much simpler using C#. Most of these calculation results are passed to Crystal Reports (via C# usually).
Which method ultimately would be the best? I can go either way really but it creates a lot of work no matter how I do it.
Cheers
