Mall statistics monthly sales are the mall should have a function, this article using the SP to achieve this, you can see how simple it is. At the same time in the statistical month should be the year also statistics, to avoid the same month of different years.
To write ASP friends a little hint: read a lot of friends write code, frequent switching between HTML and ASP, so write code has two disadvantages: first, the implementation of the program is inefficient, followed by the reading code is inconvenient, my practice is to use as much as possible Response.Write, as shown in the following code.
As far as possible to separate ADO calls and ASP pages, so as to avoid the malicious SQL injection, on the other hand, confidential data, but also make the code clearly readable.
As we all know, ASP's module function is very poor, so as developer to optimize the program structure and code.