Author: Pma_1 | Posted on: 5/3/2008 10:02:17 PM | Views : 443


Hi,

My predicament is - where do I do these calculations - in my vb.net code or in an SQL stored procedure?

My manager has handed me a task of converting an excel file she uses in to a web aplication.

While it has been easy to devise what should be the screens and how to capture data, I am struggling over how to code the calculations.

� 

The calculations in excel are pretty simple. These are just sequential calculations (about a 150 calculation for average 500 rows). Mathametical operations include sum, average, max min - regular excel stuff. Some calculations involve vlookup (equvalent to calculation based on value derived from a reference table).

� 

So I am stil wondering� - � where do I do these calculations - in my vb.net code or in an SQL stored procedure?

� 

Since these calculations are required a produce a result in an online environme ...

Go to the complete details ...