Find Jobs
Hire Freelancers

I need to be able to run a series of SQL queries against an Excel sheet, and return output from SQL into the Excel sheet.

$10-30 USD

Berlangsung
Dibuat sekitar 9 tahun yang lalu

$10-30 USD

Dibayar ketika dikirim
My company has a SQL database. We use it to track truckloads and invoices, amongst other things. We have one client where we have 216 individual EDI orders in the SQL database that need some info found out. These orders are listed in an Excel spreadsheet. One column named Invoice Number will contain the invoice numbers that need to be queried, another named Customer Load Number contains the ShipmentID that needs to be queried. Basically, if either of these queries returns 0 results, I need it to spit that info out into the same Excel sheet: select * from COMPANYNAME_INVOICE where InvoiceNumber = '%invoicenumberfromexcel%' select * from COMPANYNAME_ORDERDETAIL where ShipmentId ='%shipmentidfromexcel%' order by StopNumber asc If InvoiceNumber returns 0 results, it needs to say "invoice not found" in a status column in Excel. If ShipmentID returns 0 results, it needs to say "shipment not found" in a status column in Excel. If results are returned for both InvoiceNumber and ShipmentID, then it needs to run the following: update COMPANYNAME_INVOICE set EDIReasonCode ='' where InvoiceNumber ='%invoicenumberfromexcel%' update COMPANYNAME_INVOICE set EDIStatus = 'NEW' where InvoiceNumber = '%invoicenumberfromexcel%' update COMPANYNAME_ORDERDETAIL set Status ='COMPLETE' where ShipmentId = '%shipmentidfromexcel%' It would then spit "reprocessed" into a status column in the Excel sheet. My boss gave me the OK to farm this out. I am not a SQL guy, we have no DBA other than an outsourced data warehouse consultant who would charge data warehouse consultant hourly rates. My boss doesn't have the time to do this, I have no co-workers, and I would rather not manually check 216 individual invoice #s and shipment IDs through those lines normally, which is what we've already done for several hundred orders over time to manually identify why they bounced back from our client's EDI.
ID Proyek: 7626885

Tentang proyek

3 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
A proposal has not yet been provided
$25 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
3 freelancer menawar dengan rata-rata $117 USD untuk pekerjaan ini
Avatar Pengguna
Hello Sir, Greeting for the day, Hope you are doing well I am Working with Data Center Organization as a Software Support Engineer, I have more than 8 years’ experience in Windows/Linux Server administration , Website Hosting (Cpanel/Plesk) migration, Mail server configuration management ,CISCO Router Switches, Firewall(ASA,PIX,Sonicwall, cyberoam) ,Cloud Computing(AWS/Azure,office365).I read your Requirement and able to perform task successfully. Please add me in Skype (karunakartiwari) for details discussion about your requirement. Thanks karun
$300 USD dalam 4 hari
4,5 (9 ulasan)
4,0
4,0
Avatar Pengguna
Hi, I am interested in this project. Please let me the details of excel, so that I can provide you the solution. Thanks
$25 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED STATES
United States
0,0
0
Memverifikasi Metode pembayaran
Anggota sejak Mei 7, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.