Calculate Averages and Display on a Webpage RRS feed

  • Question

  • User1122355199 posted

    Hello everyone and thanks for your help in advance.  I have been collecting customer satisfaction data from a survey consisting of 32 questions, each with a numeric score.  I now need to calculate the average answer value for each question and display each value next to the corresponding question on another webpage.  The data is stored in a SQL Server database.  I've never really attempted this type of application before and am confused as to where the business logic should be performed, i.e. within SQL Server itself or some type of C# business layer.  Furthermore, to be honest, I'm not really sure of an efficient way to do this other than to do a select on each question, calculate the average, then move on to the next question, etc.  This seems to be a very inefficient way of handling things, but its maybe the only way.  Any insight on how to proceed would be appreciated.

    Thursday, June 28, 2018 10:21 PM