Find Jobs
Hire Freelancers

Change the sql script to get a different format

$30-250 NZD

Completed
Posted almost 5 years ago

$30-250 NZD

Paid on delivery
We have a SQL scripts that function properly until now. We need modifications to the script to produce a different format Currently we cannot provide access to the database that been used (but this script only accesses two tables from the database mention above) Please see and study the attachment as follows 1. The script that is currently used 2. CSV file generated ( AirNZ monthly db APR 19 AKL+WGTN - ORIGINAL) 3. The desired CSV file (SAirNZ monthly db APR 19 AKL+WGTN - AMMANDED) --> PLEASE HAVE A LOOK AT GREY AREA Labour --> Total "LineTotal" for "StkType"="Labour" Part --> Total "LineTotal" for "StkType"="Part " Consumables --> Total "LineTotal" for "StkType"="Consumables " Freight --> Total "LineTotal" for "StkType"="Freight " Outwork --> Total "LineTotal" for "StkType"="Outwork" [login to view URL]
Project ID: 19746973

About the project

46 proposals
Remote project
Active 5 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
Hi, I Would like to work for you on script changes. I have gone through to the details and attached files and got fair idea what we need to get in desired results. As you said we don't get database acres but if you can share table structures and some sample data with few rows. Tables : Fleet_Job_JobMaster FLEET_JOB_JobDetails Sys_ReasonCode FLEET_FleetMaster This will help get better understanding to get the values for new fields. Labour, parts, consumables, outwork and freight. I am expertise in Plsql, mssql, mysql, postgresql and have strong command over writing complex queries and using database features like procedure, functions, cursors, loops, case, aggregate functions etc.. I am a full stake developer and can work independently to deliver quality work within timelines. I have 8 years of experience in IT. Thanks, Sudesh Arora
$100 NZD in 1 day
5.0 (6 reviews)
3.3
3.3
46 freelancers are bidding on average $136 NZD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$200 NZD in 4 days
5.0 (267 reviews)
8.0
8.0
User Avatar
Hi there, thanks for the sample csv files, I can modify the query as requested. Please reply, thanks!
$70 NZD in 2 days
4.9 (90 reviews)
5.6
5.6
User Avatar
I m a database administrator with 8 years of experience in this industry. I read your project details and attached files and I understood your needs ,I can do what you want in the deadline just contact me and we can discuss more about the project.
$200 NZD in 10 days
4.9 (24 reviews)
5.3
5.3
User Avatar
Dear Sir/Madam, Please provide more details ***************************************************************
$155 NZD in 3 days
5.0 (18 reviews)
5.3
5.3
User Avatar
I believe you want to add few columns in existing csv file while exporting. How you are exporting data into csv. Are you using any ETL task or simple SQL query to export? I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$150 NZD in 2 days
5.0 (32 reviews)
5.0
5.0
User Avatar
I have loads of experience with SQL Server and can quickly make good and fast queries. If you award me this task, I will need a list of field names and types from the two tables in question. With this, I can quickly update the SQL query to meet your requirements (as I saw in your Excel sheet). If I see anything that can be optimized in terms of performance, I will let you know so you can decide if you want to include that in the deliverable.
$166 NZD in 1 day
5.0 (5 reviews)
4.8
4.8
User Avatar
Dear Sir, My name is Ali and I can work on the project with immediate availability. Let us have a quick discussion over the project so I can work on the job.
$100 NZD in 5 days
5.0 (35 reviews)
4.9
4.9
User Avatar
Hi. I've read carefully your job description I'm have a lot of experiences in JAVA, C++, VB, DATABASE ,SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will try my best level for your project to run successfully. Looking forward to hearing from you. Thanks.
$140 NZD in 7 days
4.9 (14 reviews)
4.6
4.6
User Avatar
i can modify in less than 2 days about.. please initiate chat so we can discuss in detail... #### ------ Short Info About me : With over 14+ years of experience in the industry, I have been able to craft strong knowledge of the science that goes behind web development, web designing and software development. I have fair knowledge in dealing with clients, business launches, websites, digital marketing, SEO, business strategies, mobile development and more. # Excellence in crafting .net websites with simplified source coding systems # Vision to provide for a exclusive strategies, ideas and vision of creating a business venture # Web pages designing and development, software designing and development # CMS website development, Email services, APIS development, Application development etc. # ASP.NET , .NET Core , MVC , WPF With constructive building of ideas and innovations, expect only budget-friendly and positive development of your business! Let’s connect to maximize on your ideas!
$111 NZD in 3 days
5.0 (6 reviews)
4.6
4.6
User Avatar
Hi am expertise in sql querying and also in etl processing ping me if u are interested i will give you the best
$111 NZD in 2 days
4.9 (21 reviews)
4.6
4.6
User Avatar
Hi, I have 7+ years of experience working in Top IT companies as a Database Developer. I ham proficient in writing SQL queries and I have completed multiple projects on SQL as a Freelancer as well with 100% accuracy rate. I have gone through your project requirement of adding more records in the report file. I can do that as required with maximum efficiency within the given timeline. Please ping me if you want me to work on it.
$155 NZD in 1 day
5.0 (12 reviews)
4.1
4.1
User Avatar
Hello! I read your description carefully. I've always done my project the fastest and the highest quality. I think your project is best for me. The reason is that I am a Web development expert. If you want to check my skill, you can sure from my profile. To confirm this, please see the link below. https://www.freelancer.com/u/fastestJohn?w=f If you choose me, I will do my best. Thanks.
$150 NZD in 3 days
4.8 (3 reviews)
3.4
3.4
User Avatar
I have 20 years in Database Developing, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, and MS SQL server
$140 NZD in 7 days
5.0 (5 reviews)
2.5
2.5
User Avatar
 Over 7 years of IT experience in various domains as Developer that includes Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SQL Server 2014/2012/2008R2/2008, SSAS, SSIS, SSRS and TSQL.  Extensive experience in Database development for OLAP Systems (SSAS, SSIS, SSRS) using SQL Server 2016/2014/2012/2008R2/2008.  Development and Performance tuning of the stored procedures databases using Execution Plan, SQL Profiler and Database Engine Tuning Advisor.  Automated data load process for the business using SQL jobs.  Extensive experience in Analysis services development (both star and snow flake schemas) of multi-dimensional models and tabular models using SQL Server 2014/2012/2008R2/2008.  Extensive ETL experience using SSIS for Data Extractions, Transformations and Loads.  Extensive experience in providing Enterprise Reporting solutions using SSRS 2014/2012/2008R2/2008.  Have hands on experience in .Net(C# as well as VB Script).  Hands on experience in analytics tools like Power BI and MicroStrategy (version 10.2) tools.  Have hands on experience in automation of the daily tasks by using PowerShell.
$140 NZD in 3 days
5.0 (2 reviews)
0.6
0.6
User Avatar
Hi , Hope you are doing well. I am excited to work on this project.I read a description and i will complete the project in 1 day. I am web developer and having 3 years of experience.  Expert: 1. Wordpress , PHP, C# , HTML ,Javascript, MYSQL - MSSQL. Please give me an opportunity. Thanks
$87 NZD in 1 day
5.0 (2 reviews)
0.3
0.3
User Avatar
Hello, I am Li ZeEn. Nice to meet you! I saw your job poster and interested in your project. I have good skills with that, so i wanna working with you. Don`t waste your money and time. And provide fast speed work and high quality for your satisfaction! Thanks.
$150 NZD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I am very interested in your post project. I am sure i can provide you perfect result as you want since i have rich experience on it. Actually, my slogan is "Time is Money". so i will do my best for your project and i will finish your project as soon as possible. please call me Dmitrii. looking forward to working with you. if i have a chance to work with you, it will be my pleasure. best regards
$155 NZD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I’m quality individual. My top most priority is to get your work done by any means possible. No matter how tough the work may seem to me, I’m ready to deliver it in time. I’m trying to understand the requirements clearly, incorporate feedback effectively and delivered high quality output on time I’m pretty sure you will satisfy with my job. Thank you.
$140 NZD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"
$140 NZD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, this looks like a pretty straight forward update to the SQL query you have provided. The only question I'd have is which table is "StkType" in? Once I have this information I could modify the query to add the 5 additional totals no problem. As for my experience I have been working professionally in IT Consulting for the past 4 years, and work with SQL on a daily basis.
$120 NZD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NEW ZEALAND
Auckland, New Zealand
5.0
79
Payment method verified
Member since Dec 11, 2013

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.