SQL Automation/Query/Reporting

Listing Details
Buyer	Harry (No Feedback) 0 Reviews Member Since: 30th Oct 2009 from United States View Private Messages View Public Message Board
Budget	Free budget
Service Category	Websites, IT & Software
Posted	05/11/2009 am 10:43 GMT
Bidding ends	12/11/2009 am 10:43 GMT
Remote facility data management, query, and reporting -5 users with access to the same databases -Automated and scheduled import of tab delimited txt files to append existing SQL databases (SQL Server Authentication) -TXT files for each individual location will share a similar naming convention (OKLAtransactions.txt, OKLAlinetemp.txt, OKLAtankgauge.txt, etc) -Ability to correct individual databases using additional columns in table instead of overwriting original data -Ability to use specified data to calculate new columns (i.e. subtract two date columns to find the elapsed time and create a new column) -Automated and scheduled report generation based on predefined queries (ie query all company codes matching 400 between 10/01/09 and 10/31/09 sorted by date) -Reporting will be date sorted and include the sum of specified columns with a subtotal for each day (examples will be provided) -Ability to edit reports once they are created -Abili

Sort Results By:
Options	Service Provider	Bid Amount	Delivery Time	Time of Bid
	lancerboy (No Feedback) 0 Reviews	$125.00 USD	3 days	17/11/2009 am 10:33 GMT
Comments: See PM...........................