Change the sql script to get a different format

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

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

Hi there, thanks for the sample csv files, I can modify the query as requested. Please reply, thanks!

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.

Dear Sir/Madam, Please provide more details ***************************************************************

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;

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.

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.

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.

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!

Hi am expertise in sql querying and also in etl processing ping me if u are interested i will give you the best

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.

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.

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

 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.

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

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.

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

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.

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"

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.