Terminé

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]

Compétences : Data Extraction, Traitement de Données, Programmation de bases de données, Serveur SQL Microsoft, SQL

en voir plus : 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

Concernant l'employeur :
( 65 commentaires ) Auckland, New Zealand

Nº du projet : #19746973

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% NZD en 1 jour
(6 Commentaires)
3.1

54 freelance font une offre moyenne de $137 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 4 jours
(190 Commentaires)
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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(39 Commentaires)
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]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(21 Commentaires)
5.3
expertatwork

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 2 jours
(80 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 5 jours
(26 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 7 jours
(14 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(6 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 7 jours
(5 Commentaires)
4.3
FreelancerTechX

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(6 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 2 jours
(16 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 7 jours
(4 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 10 jours
(13 Commentaires)
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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 7 jours
(9 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% NZD en 1 jour
(9 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 2 jours
(8 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 2 jours
(7 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 7 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% NZD en 1 jour
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(1 Évaluation)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 7 jours
(3 Commentaires)
1.6