Find Jobs
Hire Freelancers

Need A SQL Server Query Developed

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
Need 3 - 4 tables joined to show employee sales, employee hours worked on a day to day basis. Also need to still have the date display, but show a 0 in the column if the employee did not work for that day. Data structure/naming convention is horrid for the set-up but it's what the database has been set as for 10 years and isn't changing for now unfortunately.
Project ID: 6872454

About the project

49 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have 3 years experience in mysql programming.....I have done similar type of work in the past check my portfolio and inbox me for more details....
$10 USD in 1 day
5.0 (8 reviews)
3.6
3.6
49 freelancers are bidding on average $28 USD for this job
User Avatar
Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 3+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I used to develop systems using latest adaptive technology such as 1. .NET/ASP.NET - MVC4,MVC5 - Entity Framework - SQL - C# (for .NET solutions) 2. JQuery/Javascript/HTML5 - Angular.js/Bootstrap etc (for designing and front end implementations) I want to start work immediately and awaiting for your positive response on skp id "agilepksolutions" so I can show you some of my Quality Development Work as well as we can discuss project in details. Thank you.
$24 USD in 1 day
5.0 (71 reviews)
7.8
7.8
User Avatar
Hello Sir, Greeting for the day, Hope you are doing well I am Working with Data Center Organization as a Software Support Engineer, I have more than 8 years’ experience in Windows/Linux Server administration , Website Hosting (Cpanel/Plesk) migration, Mail server configuration management ,CISCO Router Switches, Firewall(ASA,PIX,Sonicwall, cyberoam) ,Cloud Computing(AWS/Azure,office365).I read your Requirement and able to perform task successfully. Please add me in Skype (karunakartiwari) for details discussion about your requirement. Thanks karun
$100 USD in 1 day
4.8 (52 reviews)
6.7
6.7
User Avatar
Hi I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
$25 USD in 0 day
5.0 (76 reviews)
6.3
6.3
User Avatar
Hi. I'm very strong with SQL, I can help you quicklyin this project Let me know if you have any question. Thanks for considering. Dang
$64 USD in 1 day
4.7 (20 reviews)
6.0
6.0
User Avatar
Professional Summary I am an experienced in Scala/Java, javascript programmer with an engineering degree in Information Technology. With my experience in IT products and services I will be able to provide professional help for you. Skill Set Languages/Methodologies : Scala, JAVA, XML, JavaScript and UML Technologies Client/Server : Play Framework, Spring, JSF, Servlets, and SWING Server : EJB, JPA, JDBC, JNDI, Akka DI : Google Guice, CDI Other : SBT, JMS, JTA, JAX-WS, JAX-RS, JavaMail Servers : Tomcat, Glassfish, JBoss Databases : MongoDB, MySQL, PostgreSql IDE : Eclipse, Net beans Scripting/Markup Languages : Javascript, AngularJS, HTML Operating System : Windows 7 I have more than 5+ years experience in Java and 1+ years experience in Scala. My Java experience include JSF, Spring, JPA and Scala experience include play framework, akka, slick and reactivemongo. I have good knowledge in javascript, jQuery and AngularJS. I have used javascript for more than 4 years
$25 USD in 2 days
5.0 (1 review)
3.5
3.5
User Avatar
Sir, This is my first bid in the freelancer site, I have done my OCA and have been developing complex sql queries for almost an year. Writing complex queries always fasinates me. I just need an opportunity to showcase my sql skills. Also my current work involves joining multiples tables in data warehousing project and hence i feel i can do your task efficiently and quickly. Thanks, Pramila.
$20 USD in 1 day
5.0 (9 reviews)
3.3
3.3
User Avatar
A proposal has not yet been provided
$15 USD in 2 days
5.0 (1 review)
3.0
3.0
User Avatar
Get your problem solved quickly! i will use my expertise which exceeds 6 years to perform your task. In fact, i am an oracle database developer originally, where I have great experience in creating, manipulating, administrating various types of database, i used to perform complex queries on Oracle, MySQL, SQL server (I am working on a similar task right now and it's close to the end ) Also i can deal with data on an Excel file or CSV file or even a text file (with specified format), then i can work out queries on those files as you need. /*******************/ Note : May be i am a new freelancer on freelancer.com, but be sure that i am not a new programmer :) Allow me a minute of your time, you can view my profile and portfolio. /********************/ Also you will get a coordinated results and hints, and may be you need me in other issue, because always i think out of the box. So i wish i can work with you from NOW, really right now. You can contact me via PM to discuss further details.
$20 USD in 1 day
5.0 (2 reviews)
2.4
2.4
User Avatar
The given quries can be handled easily. I got 7 years of experiance in Databases Oracle & SQL server. Will solve the issue on immergincy basis.
$35 USD in 2 days
5.0 (1 review)
2.3
2.3
User Avatar
I have strong experience in T-SQL Developping, more then 5 years writing, tunning, solving issues in T-SQL code. Reconstruction to maximize the performance of the database. I have all instruments for working. SELECT @@VERSION GO USE [DataBase] GO SELECT TOP 10 * FROM UserTable Users (Id,Login, FirsName,LastName,IsActive, CreatedDate) Employee (ID,FirsName,LastName,LastActivTime,IsActive,CreatedDate,UsersId) Employee_History (ID,FirsName,LastName,LastActivTime,IsActive,ChangeDate, UsersId) Sales (Sales_Id, EmpI_Id, Position, Date,IsActive,PartNuber, Qty, CreatedDate, UsersId ) Sales_History (Sales_Id, EmpI_Id, Position, Date,IsActive,PartNuber, Qty, ChangeDate, UsersId) CLS_ Position (Id, Desc,isactive, ChangeDate, UsersId, EmpI_Id) Fast speed completed. Please let me this work. Thank you.
$20 USD in 1 day
5.0 (2 reviews)
1.2
1.2
User Avatar
I read your description. I am familiar with the functionality you mention in the description. I'll provide you the work as per your requirement with in a particular time frame.
$44 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do it for You. You just need to tell me do You have tables or need to create them. Queries aren't problem, and the naming doesn't represent problem. We can give aliases to the columns in the queries.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
If you provide the Table names and the columns available in each table and an example of what the output you are looking for I can have this completed within 24 hours.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience in writing sql queries. i can help on this you .i already have 3 years experience in database.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I joined to many projects for three years which have to use Oracle, mysql, Micrsoft SQL Server, so I'm sure that you will feel glad with my product. please feel free to contact me via skype: nguyenntse90074
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 10+ years experience of software development using Foxpro2.6(dos), Visual Foxpro 6 & 9, SQL Server 2000,2005,2008, C#, ASP.Net, MVC, Crystal Reports,MySql, HTML, CSS, JavaScript, jQuery, jQuery UI, Foundation etc. I have developed lot of client/server database softwares like Accounting, Inventory, Taxation, Payroll, Production, ERP Implementation and more. I am proficient in MS Sql writing complex queries, stored procedures, functions, triggers, query optimization and performance tuning. Please provide full details along with database schema. Thank you, Pramod
$30 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked on SQL platform from past 3 years, I have single handedly given Backend support in MySQL to android application of our team which won best project award in UTA. I am available whole day to work as I have sem vacations and would be able to dedicate all of my time to work on it.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I make SQL queries every day to represent a data from our financial, technical and security systems.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Madison, United States
4.9
43
Payment method verified
Member since Feb 11, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.