I have a small number (10) of SQL queries to be written. My knowledge of SQL is basic so I need assistance.
All the queries are against a single SQL Server 2005 database table and I have full documentation of all the columns and permitted values.
To give an idea of a typical query, each record will have an associated "time created" column. I need a count of how many records were generated, on average, per hour for the most recent 24 hours.
It's a little more involved than that, but the essence of the project is the [url removed, login to view] fact, 4 out of the 10 queries are very similar to the above, but with differing time intervals (per 15 minutes, per 30 minutes, per 60 minutes and per day over the most recent calendar month.
Attached is a spreadsheet detailing the queries. Once I have selected who will deliver the project I will make the full table definition and sample data available.
Finally, I want to make it totally clear that all copyright, intellectual property, source code etc etc is owned by myself, not the contractor, at the end of the assignment.
56 freelancers are bidding on average £43 for this job
I understood the requests and I have good experience in SQL queries so it will be a nice job for me. I am a trusty person, I will complete the work in due time and high standards. Doina
Hi, I am having 5 year of experience with sql server 2005 and .net. i have all the experties in writting queries. You will got you job done with in specified time period . -saurabh