Suoritettu

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]

Taidot: Data Extraction, tietojenkäsittely, Tietokantaohjelmointi, Microsoft SQL Server, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 65 arvostelua ) Auckland, New Zealand

Projektin tunnus: #19746973

Myönnetty käyttäjälle:

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 Lisää

$100 NZD 1 päivässä
(6 Arvostelua)
3.1

54 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$200 NZD 4 päivässä
(190 arvostelua)
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] Lisää

$155 NZD 3 päivässä
(39 arvostelua)
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 3 päivässä
(21 arvostelua)
5.3
expertatwork

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

$70 NZD 2 päivässä
(80 arvostelua)
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 5 päivässä
(26 arvostelua)
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 Lisää

$140 NZD 7 päivässä
(14 arvostelua)
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 Lisää

$111 NZD 3 päivässä
(6 arvostelua)
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 7 päivässä
(5 arvostelua)
4.3
FreelancerTechX

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

$155 NZD 3 päivässä
(6 arvostelua)
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 2 päivässä
(16 arvostelua)
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 Lisää

$200 NZD 7 päivässä
(4 arvostelua)
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 Lisää

$200 NZD 10 päivässä
(13 arvostelua)
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 7 päivässä
(9 arvostelua)
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 Lisää

$155 NZD 1 päivässä
(9 arvostelua)
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 Lisää

$150 NZD 2 päivässä
(8 arvostelua)
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 Lisää

$100 NZD 2 päivässä
(7 arvostelua)
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 Lisää

$140 NZD 7 päivässä
(3 arvostelua)
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 Lisää

$250 NZD 1 päivässä
(1 arvostelu)
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 Lisää

$155 NZD 3 päivässä
(1 arvostelu)
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 7 päivässä
(3 arvostelua)
1.6