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]
54 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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]
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.
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
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!