In Progress

SQL Query Writing

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.

Skills: SQL

See more: writing minutes, writing definition, sql server contractor, small writing table, number writing, n query, definition writing, contractor per hour, code writing, clear writing, basic writing, writing sql queries, sql query, sql queries, sql code, record writing, query table, need column writing, data source sql, data query, definition, sql created, selected records, small writing, table queries

About the Employer:
( 1 review ) Edgworth, United Kingdom

Project ID: #1277315

Awarded to:

MattThrower

I have 8 years experience doing this sort of work.

£30 GBP in 2 days
(6 Reviews)
4.2

56 freelancers are bidding on average £43 for this job

HussienSharaf

HI, I m the best SQL expert. Plz check my profile. I can finish in few hrs. Hussien Sharaf

£30 GBP in 1 day
(13 Reviews)
6.3
eperfections

Please see PMB

£75 GBP in 1 day
(70 Reviews)
5.9
thanhlongfree

Hello. Please check PM

£50 GBP in 2 days
(16 Reviews)
5.1
tejas34

I went through your requirement. I am sure I will provide one of the best solution to you. I have 8+ years of experience and expertise in SQL SERVER 2005/2008, MySQL & MSAccess, XML. I have strong skills in deve More

£40 GBP in 1 day
(17 Reviews)
5.1
marasinghe82

Dear Sir, I'm ok for start right now . I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last three years I involved many project in ETL, data warehousing, BI reporting and five years of More

£20 GBP in 1 day
(28 Reviews)
4.6
firstterra

Dear Nobius, could you please check your PM? Thanks.

£50 GBP in 1 day
(9 Reviews)
4.5
dobreiiita

Lets do this.Thanks

£50 GBP in 2 days
(21 Reviews)
4.4
manhpham

I have many experience with SQL server. Please contact me for help.

£60 GBP in 0 days
(10 Reviews)
4.3
mpro1

I can do it.

£20 GBP in 0 days
(3 Reviews)
3.4
netcoder

Hi, I think I can do it:-)! Best regards, netcoder:-)

£55 GBP in 5 days
(6 Reviews)
3.3
ezzarghili

Hello sir, I am proficient on SQL server 2000/2005/2008 it's in my line of work as an IT Exploitation Responsible for a years of data exploitation from different db schema, with complex data organization and hundred of More

£25 GBP in 1 day
(2 Reviews)
3.2
manohartvs

Hi Mate, I work as an Analyst on SQL Server 2008 and 2005 regularly. I can code up your queries for you. I am ready to start immediately. Cheers

£40 GBP in 3 days
(2 Reviews)
2.5
sathish2connect

Hi, I have good knowledge in SQL. Please send me the details. Ready to start now.

£30 GBP in 2 days
(6 Reviews)
2.3
doinab

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

£20 GBP in 1 day
(3 Reviews)
2.3
freelancerbuzzo

Ready to start right now.

£30 GBP in 1 day
(2 Reviews)
2.0
scs24101983

Hello, I am a software engineer having 6 years of experience in SQL and C#.net. Your requirements are very clear. I am interested in this work. I can start the work immediately and will finish in 2-3 days. More

£25 GBP in 3 days
(2 Reviews)
1.6
oxsteam1

Just starting out with freelancer.com, but I am a professional developer with 12 years experience with over ten in MS SQL. Since these queries would all be hitting the same table I see no reason why it would take long More

£25 GBP in 2 days
(0 Reviews)
0.0
Saurv

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

£20 GBP in 2 days
(0 Reviews)
0.0
mrgugu

I'm a certified MSSQL db admin, so there shouldn't be any prob doing the job.

£20 GBP in 1 day
(0 Reviews)
0.0
amrendra4it1

Hi, I had seen your requirement.I have 6+ years of experience in Sqlserver, Asp.net and c# I can deliver that you require

£20 GBP in 1 day
(0 Reviews)
0.0