Project Detail

Help in writing SQL statements

Help in writing SQL statements is project number 314365
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: dleony

Budget: $30-250

Created: 09/13/2008 at 7:14 EDT

Bid Count: 12

Average Bid:
$ 71

09/20/2008 at 7:14 EDT

Project Creator: mpt offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (12 reviews)

Description

For continuous projects involving SQL database access I need email support in creating SQL statements.

I had been writing SQL statements by myself, so I do have the basic knowledge and skill. But since this has been more than 3 years ago I have forgotten much of it. Now I have some personal projects where I need to write my own code again and have trouble getting forward with my project quickly. Basically I could research the answers to my problems online but this takes to much time. I would like ask my questions to you by email and get specific answers/SQL statements.

Since my questions come up over a period of time, this project will not be finished until a certain day. I would like to buy a certain amount of hours from you, and then use up this time when I have questions. If you are an SQL expert my questions will be simple for you to answer. An example of a typical question is "What is the SQL statement to read a text file into a MySQL table?"

Currently I am accessing a MySQL database on a webserver, using an SQL Editor (WinSQL) on my local PC, and need to up/download text files from/to my local PC.

Please make an offer for an initial support package of 5 hours. In your bid, please explain to me how quickly on average you could respond to my emails (e.g. usually within less than x hours/days) and give me your local time zone (so I now when to expect answers). I won't expect you to always answer within the stated time period but on average it should be the objective. I will pay 20% of the amount you bid after each 1 hour spend for supporting me.

In the future I might also have questions about Perl and PHP, so if you are skilled in these as well, please mention it. But it is not required for this project.

Important: If you are seriously interested in this project, please mention briefly which kind of experience you have.

Report Violation

Job Type

Data Processing

See more: access, bid, code, database, editor, email, emails, make, mysql, online, perl, project, projects, research, simple, sql, support, text, write, writing

Messages Posted:1

If you are the project creator or one of the bidders Log In for more options

PMB

0 days

09-13-2008 09:22 EDT

9.9199/10
(387 reviews)

Quick replies... Thanks

VisionsUnleashed offline

1 day

09-13-2008 10:23 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(10 reviews)

[where 1 day is a placeholder for 5 hours only] Please check PMB for answers to your queries. Thank you.

dleony offline

0 days

09-15-2008 05:03 EDT

9.8333/10
(6 reviews)

I'd be more than glad to work on this project.

radus28 offline

1 day

09-13-2008 11:01 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(4 reviews)

I have impressed your requirments, because it will be efficient for me to manage my time by doing your work through email. ( others asking online). I can give you $20 for your first 5 hrs offer. My available time could be 07.00am -12.30pm of UK time. but i shall process your request over all available time. I am a PHP/mysql programer, I will PM you my past work profile. So it will be easy to clear your sql doublts as well as PHP/mysql. See PM for further details

haiderabbasnaqvi offline

0 days

09-13-2008 08:48 EDT

(No Feedback Yet)

I can provide you certain support, as i am normally available online.

edeiaweb offline

0 days

09-13-2008 15:38 EDT

(No Feedback Yet)

More than 10 years of experience in SQL writting, including 5 in the Financial Sector. We can even work online, with MSN or Skype.

AMWorx offline

0 days

09-13-2008 15:52 EDT

(No Feedback Yet)

Dear sir, We are software engineers not just coders so we'll supply the correct answers and best in performance. thank you.

yogysalvi offline

1 day

09-15-2008 15:29 EDT

(No Feedback Yet)

We had worked for MySQL query optimization and we have good experience of writing optimized and simplified the mysql queries. Give us chance to prove ourselves. Thanks and Regards, Yogesh Salvi

manoharanav offline

250

1 day

09-16-2008 00:47 EDT

(No Feedback Yet)

Please see the PM and a sample code. Thanks and regards.

cyberstrike offline

250

1 day

09-16-2008 03:00 EDT

(No Feedback Yet)

My bid is $100/hr; if the project extends over 7 hours then the price drops to $70/hr thereon for that given project. Typical response time is 2-3 hours and I am in the PST time zone. I respond in mornings, evenings, and weekends as well. I have worked on some of the largest SQL Server 2000 and 2005 servers in the world for MGM Mirage, Wynn, General Motor, and several fortune 500 companies. I have worked with General Motor's Oracle 9.2 legal database system, so I have extensive experience with databases that handle over 40+k transactions a second and databases 3+ TB for both Oracle and SQL Server. I have over 8 years of experience working with SQL Server. I was also the lead performance developer on the MGM Mirage SQL Server 2005 systems for the vendor IGT, which utilizes several linked servers and replication. I also have experience working with over 10 filegroups. I am the architect of several high-availability/low downtime solutions utilizing replication/database mirroring. I also have 6 years worth of experience working in .NET C#/VB.NET application; however, I do not design Web GUI interfaces. I currently work as the Database Systems Manager at Station Casinos managing over 100 servers, 170+ databases, and over 20+TB of data. I write SQL Server tips for SearchSQLServer.com and have served as a performance consultant for several companies. I can provide professional references to verify all of this. Finally, I am a certified MCITP: Database Developer (SQL Server 2005) and MCTS: SQL Server 2005. Please feel free to contact me with any questions. Please feel free to contact me for further information and detailed information on my prior projects. I currently live in Las Vegas and can be on-call during evenings, nights, holidays, and weekends for urgent issues that occur. I also have additional DBA resources that I work with at Wynn and IGT that can also be utilized if needed. I have a blackberry for on-call support, so I am available via phone or email at all hours as needed.

crossplatform offline

1 day

09-16-2008 11:22 EDT

(No Feedback Yet)

Prifessional DB programmer - RDBMS (SQL) and Multi-Value (PICK). Advanced SQL - multiple joins, unions, etc. I'll need a copy of your database layout, preferably with the data. I can work weekends and evenings - after 5:30pm CST. This rate is trial - for the first 5 hrs. If you decide to use my service after that, we'll have to re-negotiate the rate.

touseefali offline

1 day

09-17-2008 06:08 EDT

(No Feedback Yet)

I m a professional i m doing my job as Project Manager and i have 10 years experience of SQL Server 7.0, 2000, and 2005. Can i help you please. Thanks

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.