Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Update SQL reporting script written in VBS
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.


Job awarded.

Nov 19, 2010

Job Description

  |  Change History >>


  • Posted: Tue, Nov 16, 2010
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have a VBS script that emails information based on SQL queries. It queries the database for information and Bookings (customer visits) on Resources (employees of the company). The VBS script runs the queries on a Windows 2003 server. The VBS script is started using Windows Task Scheduler.

I would like the following changes/enhancements:
a. Add ability on all queries to exclude certain Resources from being queried, and modify which Resources are excluded when needed.
b. Stop all queries reporting bookings scheduled on Saturday and Sunday.
c. Add ability to independently stop certain queries in the VBS script from being run.
d. On the "Availability" query, add the following: If the Resource has Booking Type "Not in Office", it should also appear in the "Engineers Unavailable/Busy" line.

I can supply export of SQL database and access to the server using TeamViewer (this will be monitored though for security!)

Sign in or Register to see more

Desired Skills
Visual Basic, SQL
Job ID: 21943591
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Australia  |  
Reliable and experienced software engineer based in Australia with over 10 years of commercial software development experience in various...
 0.0   |  Private   |  1 Jobs
Bid ID: 21949263  |  Submitted: Nov 17, 2010 04:18 ET 
Within 2 weeks

 India  |  
Athena eSolutions is a company run by software professionals for professional clients like you.It is a highly motivated team which provides world...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 21944080  |  Submitted: Nov 16, 2010 17:49 ET 
Proposal SEALED

 India  |  
I specialize in .Net, web design and front-end development using XHTML, HTML5, CSS2, CSS3 and Javascript (jQuery library). I've been developing...
 0.0   |  Private   |  0 Jobs
Bid ID: 21943960  |  Submitted: Nov 16, 2010 17:33 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »