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]

Beceriler: Data Extraction, Veri İşleme, Veritabanı Programlama, Microsoft SQL Server, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 65 değerlendirme ) Auckland, New Zealand

Proje NO: #19746973



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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% NZD
(6 Değerlendirme)

Bu iş için 54 freelancer ortalamada $137 teklif veriyor


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 Daha Fazla

$200 NZD in 4 gün içinde
(190 Değerlendirme)

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] Daha Fazla

$155 NZD in 3 gün içinde
(39 Değerlendirme)

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 gün içinde
(21 Değerlendirme)

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

$70 NZD in 2 gün içinde
(80 Değerlendirme)

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 gün içinde
(26 Değerlendirme)

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 Daha Fazla

$140 NZD in 7 gün içinde
(14 Değerlendirme)

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 Daha Fazla

$111 NZD in 3 gün içinde
(6 Değerlendirme)

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 gün içinde
(5 Değerlendirme)

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

$155 NZD in 3 gün içinde
(6 Değerlendirme)

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 gün içinde
(16 Değerlendirme)

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 Daha Fazla

$200 NZD in 7 gün içinde
(4 Değerlendirme)

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 Daha Fazla

$200 NZD in 10 gün içinde
(13 Değerlendirme)

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 gün içinde
(9 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(9 Değerlendirme)

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 Daha Fazla

$150 NZD in 2 gün içinde
(8 Değerlendirme)

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 Daha Fazla

$100 NZD in 2 gün içinde
(7 Değerlendirme)

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 Daha Fazla

$140 NZD in 7 gün içinde
(3 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(1 Yorum)

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 Daha Fazla

$155 NZD in 3 gün içinde
(1 Yorum)

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 gün içinde
(3 Değerlendirme)