Færdiggjort

Change the sql script to get a different format

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]

Evner: Data Extraction, Databehandling, Programmering af database, Microsoft SQL Server, SQL

Se mere: running sum total sql update, import data access sql script, sql script count record sequence row, sql date format dd-mmm-yyyy, sql date format mm/dd/yyyy, sql convert date format, sql date format yyyymmdd, sql convert string to date dd/mm/yyyy, sql time format, sql convert string to date yyyymmdd, sql server convert datetime to date, sql script import text website, download file stored sql database binary format, create sql script, mmorpg php sql script text based, sql script calculate totals, sql script database changes, sql server 2000 format numbers money, oracle script naar sql script, cms class sql script create php simple page

Om arbejdsgiveren:
( 65 bedømmelser ) Auckland, New Zealand

Projekt ID: #19746973

Tildelt til:

sudesharora0111

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 ca Flere

$100 NZD på 1 dag
(6 bedømmelser)
3.1

54 freelancere byder i gennemsnit $137 på dette job

schoudhary1553

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. Pl Flere

$200 NZD in 4 dage
(190 bedømmelser)
7.6
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. Here are my working result for php, mysql, api integration, ajax, jquery etc. [login to view URL] Flere

$155 NZD in 3 dage
(39 bedømmelser)
5.9
sergioes

Hi, I have 10+ years experience with MySQL, and I can working in the updated query right right now. Regards, Sergio. --- * My professional blog [login to view URL]

$100 NZD in 3 dage
(21 bedømmelser)
5.3
expertatwork

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

$70 NZD in 2 dage
(80 bedømmelser)
5.4
AliSafder

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 dage
(26 bedømmelser)
4.5
xinglong717

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 Flere

$140 NZD in 7 dage
(14 bedømmelser)
4.5
PrasadSolutions

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 c Flere

$111 NZD in 3 dage
(6 bedømmelser)
4.6
RiHCh

Hello, How are you? I am glad to bid your project. I am Professional Database Management System Expert. I can do your project within short hours. Please contact me by chat. Thanks

$299 NZD in 7 dage
(5 bedømmelser)
4.3
FreelancerTechX

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

$155 NZD in 3 dage
(6 bedømmelser)
4.0
sreenivas2903

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 dage
(16 bedømmelser)
4.2
leemilun

Hi, nice to meet you. I have checked your project carefully, so that i feel I can do this project. I am good in web basic skill and i am familiar with some frameworks such as Laravel, Wordpress, Codeigniter, Nodejs and Flere

$200 NZD in 7 dage
(4 bedømmelser)
4.3
Proolancer

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 d Flere

$200 NZD in 10 dage
(13 bedømmelser)
4.4
xutao650

Hi I have checked the attachments. But I did't find the difference between two excels. I am a software neigneer with 8 years' experience of .net developing. Please cotact me for further discussion!

$100 NZD in 7 dage
(9 bedømmelser)
3.9
nidhi1509

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 ra Flere

$155 NZD på 1 dag
(9 bedømmelser)
3.8
jayantavkumar

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 / solu Flere

$150 NZD in 2 dage
(8 bedømmelser)
3.6
sergeyprince

Hello. I looked carefully at your posts. sql database manage & programming is my best work. also i have a enough history in this part. If you have the opportunity to talk to me, I think I can create a less cost eff Flere

$100 NZD in 2 dage
(7 bedømmelser)
2.8
bluestar1027

Hello, dear!!! I have read your description carefully. I can handle it with full confidence and have already done this type of projects. Please give me an opportunity to work with you. I am a senior Mobile and Web d Flere

$140 NZD in 7 dage
(3 bedømmelser)
2.2
logos106

Hello, there I have checked the files you attached and am interested in this work. You will get it done within hours once I am awarded. Please call me so that I can get started. Looking forward to hearing from yo Flere

$250 NZD på 1 dag
(1 bedømmelse)
2.2
KimHyokJun

Need Web Development or Business Growing? My experiences range from building responsive software design that work well cross-browser to Business Goal. I am glad to provide full solution to you. We Are in House of Web Flere

$155 NZD in 3 dage
(1 bedømmelse)
2.2
NoSonforhim

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 dage
(3 bedømmelser)
1.6