Database Totaling

I have an intranet application that allows a user to create user-defined SQL tables using a gui interface. The interface also allows the user to create views of the data and specify the sorting and grouping of the data.

The application reads the database view structure and then constructs the SQL to create the view. It essentially builds a select statement on the fly based on user-defined criteria. This is all done within a stored procedure.

I want to add the ability to perform aggregate functions (count, sum, average) on these user-defined views and think a good approach is to have the SQL perform the aggregation.

You can see the application at demo.serran.net. After you login go to Shared Database. Click the Orders link to see the data in the table. Click the Views to see how the views are constructed using the GUI interface.

I need someone to modify the existing stored procedure to enable it to create the totals/subtotals on the user-defined fields. I would like the SP to create the totals based on the information in the following artice: [[url removed, login to view]][1]

The query shown in this article is based on a static orders table. The tables in my application are dynamic so the solution needs to be generalized to create running totals on these dynamic tables.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

SQL Server 2000

Ingeniería MySQL PHP Arquitectura de software Verificación de software SQL

Nº del proyecto: #3369563

Sobre el proyecto