I have a need for a series of Database Queries to retrieve a given result set. I'd like to send you the database tables, then give you a description of the result set that I want to retrieve. I can also give you what I want the result set to look like. I am expecting the SQL queries for each description in return.
I've attached an SQL file containing a structure for a new table and some dummy data to insert. I'm looking to basically write some queries to grab the result set and format it in a way that makes sense for my app.
Example:
The table has a date column and an amount column. I want the total amount of every entry in the table, grouped by each individual day so that the result set looks similar to the following:
{[
date: 2013-06-01,
total_transactions: 0
],
[
date: 2013-06-02,
total_transactions: 0
],
etc..
}
To make sure you've read and understand the requirements, please include the word "dog bone" in your bid offer. I will not accept your bid if you do not include the word "dog bone" in your message.
Hi,
I have 8.5 years experience in MySQL database design, Queries writing and indexing. Expertize in ASP.Net|C# Win Forms|SharePoint2010|EF|WebServices|WCF|Sql Server 2005/2008R2|MYSQL||HTML5|CSS3|Jquery|Ajax|JSON|SSRS2008.
"dog bone" I write about 4,000 "complex" MySQL queries every half year, so this will be easy for me and also efficient for you. Please check out my completion rate and reviews.
Hi, (dog bone)
I have several years of experience in MsSQL.
I would love to help you with this queries. You can check my feedback.
Can you put the sample database?
Thanks,
Emilian.