Đã hoàn thành

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]

Kĩ năng: Data Extraction, Xử lí dữ liệu, Lập trình cơ sở dữ liệu, Microsoft SQL Server, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 65 nhận xét ) Auckland, New Zealand

ID dự án: #19746973

Được trao cho:


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 Thêm

$100 NZD trong 1 ngày
(6 Đánh Giá)

54 freelancer đang chào giá trung bình $137 cho công việc này


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 Thêm

$200 NZD trong 4 ngày
(190 Nhận xét)

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] Thêm

$155 NZD trong 3 ngày
(39 Nhận xét)

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 trong 3 ngày
(21 Nhận xét)

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

$70 NZD trong 2 ngày
(80 Nhận xét)

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 trong 5 ngày
(26 Nhận xét)

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 Thêm

$140 NZD trong 7 ngày
(14 Nhận xét)

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 Thêm

$111 NZD trong 3 ngày
(6 Nhận xét)

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 trong 7 ngày
(5 Nhận xét)

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

$155 NZD trong 3 ngày
(6 Nhận xét)

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 trong 2 ngày
(16 Nhận xét)

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 Thêm

$200 NZD trong 7 ngày
(4 Nhận xét)

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 Thêm

$200 NZD trong 10 ngày
(13 Nhận xét)

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 trong 7 ngày
(9 Nhận xét)

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 Thêm

$155 NZD trong 1 ngày
(9 Nhận xét)

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 Thêm

$150 NZD trong 2 ngày
(8 Nhận xét)

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 Thêm

$100 NZD trong 2 ngày
(7 Nhận xét)

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 Thêm

$140 NZD trong 7 ngày
(3 Nhận xét)

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 Thêm

$250 NZD trong 1 ngày
(1 Nhận xét)

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 Thêm

$155 NZD trong 3 ngày
(1 Nhận xét)

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 trong 7 ngày
(3 Nhận xét)