MS-SQL Stored Procedure generating MS-EXCEL Report(s)

IN PROGRESS
Bids
8
Avg Bid (USD)
$14 / hr
Project Budget (USD)
$2 - $5 / hr

Project Description:
MS-SQL Stored Procedure generating MS-EXCEL Report(s)

I currently data-mine daily traffic metrics of a web service across a hundred customers between November 2011 through February 2013. The data is imported into an MS-SQL database. I need a MS-SQL stored procedure that auto generates summarized reports in Microsoft Excel format using the data in the database described above.

The format of the source input is as follows:

create table table1(
id1 BIGINT not null primary key identity,
categoryName VARCHAR(max),
entryPoint VARCHAR(max),
TrafficDate DATETIME,
customerId VARCHAR(max),
trafficCount INT,
interface VARCHAR(max));

A sample of the data is as follows:

categoryName entryPoint TrafficDate customerId trafficCount
MMM BMMMAPP 01/21/13 34E378A4BCF48BA2E7F5270C5 673
MMM BMMMAPP 01/21/13 34E378A4BCF48BA2E7F5270C5 37
QQQ BMMMAPP 01/21/13 99F56C859DEDB259FECE90DFC 3
QQQ BMMMAPP 01/21/13 99F56C859DEDB259FECE90DFC 1
QQQ BGGGAPP 01/21/13 95750006211F1DD41F242C42B 1734447
QQQ BGGGAPP 01/21/13 95750006211F1DD41F242C42B 3495
QQQ BGGGAPP 01/21/13 95750006211F1DD41F242C42B 741
QQQ BGGGAPP 01/21/13 99F56C859DEDB259FECE90DFC 8
QQQ BGGGAPP 01/21/13 4C57DEB212BFCD1A61926EA0C 411645
QQQ BGGGAPP 01/21/13 7B5EC7E6A32858D5F2712E5FC 3219

I contain data from September 2011 through February 2013.

The objective of the reports is to illustrate the following:

1. The daily traffic (i.e. trafficCount) for every customer (i.e. customerID)
2. The day-by-day % change of traffic
3. The week-by-week % change of traffic
4. The weekly average traffic

The following are the operational requirements:

1. The reports must be generated from a SQL stored procedure
2. The stored procedure will auto generate every morning @ 5AM
3. The output of the report is in XLS format and in compliance with the XLS template attached to this project
4. The stored procedure acts on data from the range of Sep 2011 to Feb 2013
5. The reports are monthly summarized. So if the range of reports are December 2012-Feb 2013, then three (3) XLS reports are generated
6. The % change values must be configured for conditional formatting. So that if % change that is greater than 10%, then the value must be formatted in RED, whereas formatted in BLACK
7. When a report is generated and the % change is greater than 20% for any customer, the report auto emails/alerts one or more configured email addresses

................................................

PLEASE SEE THE ATTACHED FILES FOR EXAMPLES OF THE SAMPLE DATA IN MY TABLE AND WHAT THE REPORT MUST LOOK LIKE (I.E A TEMPLATE)
................................................


In addition to the above, I have a very simply 5 minute DB modificaiton script. My current table is configured as:

create table table1(
id1 BIGINT not null primary key identity,
categoryName VARCHAR(max),
entryPoint VARCHAR(max),
TrafficDate DATETIME,
customerId VARCHAR(max),
trafficCount INT,
interface VARCHAR(max));

...but I need it to be:

create table table1(
id1 BIGINT not null primary key identity,
categoryName VARCHAR(max),
entryPoint VARCHAR(max),
TrafficDate DATETIME,
customerId VARCHAR(max),
trafficCount BIGINT,
interface VARCHAR(max));

What I need is a SQL script that modifies table 1 so that trafficCount is now BIGINT. Currently, SQLSERVER prevents me from doing this directly. So I need a script that creates a new table where trafficCount is BIGINT, imports the data from the original with the EXACT same values then renames the new table to table1. The values must be the same because I have a table2 that depends on the values in "id1" column.

Hours of work: 4 Project Duration: < 1 week Skills required:
SQL, Visual Basic for Apps
Additional Files: trafficreportsproject.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$50 / hr
Hours: 4 hr/ week
$10 / hr
Hours: 4 hr/ week
Hire yeki
$20 / hr
Hours: 1 hr/ week
$8 / hr
Hours: 6 hr/ week
Hire danielmalangis
$5 / hr
Hours: 4 hr/ week
Hire nof4444
$5 / hr
Hours: 4 hr/ week
$13 / hr
Hours: 4 hr/ week
$3 / hr
Hours: 4 hr/ week