Find Jobs
Hire Freelancers

Simple SQL script needed

$10-30 USD

Selesai
Dibuat hampir 8 tahun yang lalu

$10-30 USD

Dibayar ketika dikirim
We have two databases on the same Windows 2003 server running SQL server express 2008: ´bartender´ and ´ChemeterData´. Inside database Chemeterdata, there is a column ´Pictogram1´ which holds data that is not inside database ´bartender´. This is a problem for us. We need a script, when executed, that creates an extra column named ´backlabel´ into ´bartender´ (if the column excists, it should overwrite it) and start to look if products in column ´Product_Code´ from database ´ChemeterData´ matches products from column ´Item´ from database ´bartender´. If it finds an EXACT match, then it should check if there is a value in column ´Pictogram1´ from database ´ChemeterData´ and if the cell contains a value, it should say ´yes´ into column ´backlabel´ of the matched product found. If there is no match, it should say ´no´. If there is a match, but the value in ´Pictogram1´ is NULL (empty) it should also say ´no´.
ID Proyek: 10352316

Tentang proyek

13 proposal
Proyek remot
Aktif 8 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
Hi! Nice to see you again !!!!! I can do it script fast. Need dump of both databases. .
$25 USD dalam 1 hari
5,0 (5 ulasan)
2,9
2,9
13 freelancer menawar dengan rata-rata $27 USD untuk pekerjaan ini
Avatar Pengguna
Hello, I am very much interested to do this work as i have strong knowledge in writing sql queries. I understand your requirement and i can do it efficiently. I can write a stored procedure for this purpose if you want. Looking forward to have a positive response from you. Note: In your picture3, 2 yes is correct, but will all other rows should not be 'no' ? Why only 2 are 'no' ? Thanks
$24 USD dalam 1 hari
4,9 (88 ulasan)
5,9
5,9
Avatar Pengguna
I have 5 yrs of experience in SQL development and compete your task in small time interval
$30 USD dalam 1 hari
5,0 (11 ulasan)
3,5
3,5
Avatar Pengguna
Only Pay me If you 100% Satisfy with my work As per you requirement we have a team that will definitely provide best solution to you. We do fair code with reasonable price and client satisfaction is our Responsibility. Personally we have three + years experience of web and desktop based applications using .net framework and Entity frame work and other technology related to this and third party tools as well. There are many running applications on which we have worked and delivered but we have no portfolio because we always focus to deliver support to my client. We have good team of QA (Quality Assurance) so before delivering work our departs make sure that all work is done according to the requirement and flow of the application is 100% accurate. A list of services is provided that our team has been working for the past 3 years and become an expert on. • C# Development • Vb.net • Asp.net • MVC • Web Service (Rest / Soap) • Desktop Application • Crystal Reports • Sql Server Database • Html Css • Javascript JQurey • Angular • Ajax • Java Script • Pretty much anything involves coding waiting for your responce Thanks
$50 USD dalam 3 hari
5,0 (2 ulasan)
2,6
2,6
Avatar Pengguna
i can help you
$24 USD dalam 0 hari
5,0 (1 ulasan)
2,2
2,2
Avatar Pengguna
Hi, I am Harsh Sharma, please find my proposal for your review and consideration. I am PMP and ITIL V3 Certified (93%) having more than 14 years of experience in the Software Development; and I am well versed in the designing and coding of variety of software applications using the following platforms ASP.Net, C#, SQL Server, PL SQL, Oracle. I can work on this and will complete this task in a day. Please let me know if you are interested. Thank you for your time and consideration. Regards, Harsh Sharma
$25 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I have more than 15 years on sql databaes and writing codes. Pleae let me know to have quick chat and start
$30 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Due to my experience with SQL, I hope to be a good contribution to the project. Feel free to contact me to discuss further details. Thanks in advance, Ricardo Freitas
$29 USD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$10 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I am new at freelancer and this is my first project. I already work for an organization and will work here part-time in order to add extra money in my pocket. In my parent organization, I work with databases and have done lot of work in SQL scripting. Your work is quite straightforward and I am confident enough to finish it. I ensure you 100% commitment from my side. Rest is up to you to decide. You can contact me anytime, I will make sure to respond to you at the earliest. Thanks
$25 USD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera NETHERLANDS
Weert, Netherlands
5,0
13
Memverifikasi Metode pembayaran
Anggota sejak Feb 10, 2012

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.