Find Jobs
Hire Freelancers

SQL Query to Clean Some Data

$30-250 AUD

Ditutup
Dibuat hampir 8 tahun yang lalu

$30-250 AUD

Dibayar ketika dikirim
I need and one ore more SQL query to clean some data in the following way: 1. If the BBSctr field is empty insert the most frequently used BBSctr corresponding to the SpnsrSctr of that record by that Spnsr. Note that different Spnsr may have different "most frequent" BBSctr associations. 2. When there is neither a SpnsrSctr or BBSctr search for any BBSctr association of CnsTckr and assign the most frequent there. You may not use temporary tables but you can create explicit mapping tables. Execution speed is important but not my primary concern at this time. Sample data is provided attached. Budget --- $ 60
ID Proyek: 11266995

Tentang proyek

21 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
21 freelancer menawar dengan rata-rata $74 AUD untuk pekerjaan ini
Avatar Pengguna
Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net, MVC - Linq to SQL,Entity Framework - Jquery,AngularJS,NodeJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Web API 2, WCF WebService - Application Security Remediation,Penetration Testing - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are looking for. We can discuss further on chat. Looking forward from your end. Thanks
$60 AUD dalam 2 hari
5,0 (15 ulasan)
4,2
4,2
Avatar Pengguna
Come on chat now so we can discuss more....am waiting... I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Regards, Logicmaker
$60 AUD dalam 1 hari
4,5 (4 ulasan)
3,3
3,3
Avatar Pengguna
hello project provider This is Rajesh Bhardwaj. i have 4.5+ year of experiences in web development.. till now i was done 100+ project as a freelancer ..i am interested in your project and want to work with you.. so please come in chat box for further discussion . Thanks & warm regard Bhardwaj
$77 AUD dalam 4 hari
4,6 (6 ulasan)
3,1
3,1
Avatar Pengguna
Hello there - I am an experienced SQL Developer. This indeed can be done with an explicit mapping table to store the frequency lookups as the first step, which would typically be done with a temporary table. What target SQL server is this going to? These steps can be incorporated into a script which will run each of the stages to complete the cleansing on the data. Happy to discuss you needs. /RAL.
$60 AUD dalam 3 hari
5,0 (1 ulasan)
3,0
3,0
Avatar Pengguna
SQL professional
$66 AUD dalam 3 hari
5,0 (1 ulasan)
1,8
1,8
Avatar Pengguna
Hi, I am working extensively in SQL since last 11 years. I am worked with top IT companies in past. Currently I am working as solution architect for one of the biggest IT company. I have analysed sample data and I can clean it using just 1 SQL statement. As it is my first project and first experience with freelancer, I am bidding very low.
$35 AUD dalam 2 hari
5,0 (1 ulasan)
0,7
0,7
Avatar Pengguna
Dear Sir, Greetings from Niral Patel, I gone through the detailed requirement and found that you are looking for someone who is experienced with SQL to manage your database. I have good experience in building query for custom results and i think i;m best fit for this. Here, I offer you to give my best output on your all database needs. I’m committed to best quality work with regular updates. You will get your work done before your expectations as I am very strict follow of deadlines. Looking forward to your reply Thank you!
$50 AUD dalam 2 hari
5,0 (1 ulasan)
0,0
0,0
Avatar Pengguna
I have 10+ years of experience working design and developing applications of various types and business needs. I have worked with different databases ranging from Oracle, MSSQL, mySQL, NOSQL ( mongoDB, Redis) . My highest priority is to understand what the customer requires and deliver the solution within time and budget. I am easy to communicate and always available for discussion. It would be my pleasure to work with you on this project. Cheers.
$45 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello, I have 3-4 years of DBA and experience of creating SQL queries different difficulty and tasks. For example: creating excel reports for call centers, e-mail and web-site reporting for bank with 3k employees. Creating new database for automatic interactive voice respond (AIVR) with procedures, triggers linked to bank accounts. Also have less expereince with other databases like Oracle, MySQl, SQLlite.
$60 AUD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi i will prepare query for you
$100 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I believe that I am suitable for this job since I have experience with working in SQL databases for 5 years now. I write SQL queries daily and also handle and manipulate data from external tables. In order to complete the request I plan not to create temporary tables, but to create CTEs, which I use frequently, in order to calculate the fields which I need to show. I hope we will collaborate on this project. Regards, Oana
$45 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Will deliver two SQL codes - each will use loops (if this is acceptable from performance perspective) first to loop through blank BBSctr and update with the top BBSctr value for corresponding SpnsrSctr value second to loop remaining blank BBSctr and update with the top BBSctr value for corresponding CnsTckr value
$66 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I already have the query . you can have a look if works for you fine else you always have option to hire anybody. looking forward to your chat. thank you. best regards, Muhammad
$30 AUD dalam 0 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, I would like to tell you about myself that I am currently working in INDIA's TOP MNC Software based company. Having 4.5+ yrs of experience in SQL and 3+ yrs experience in SAS . I would like to nominate myself for this job. I just joined the Freelancer so giving offer like free of cost. You can trust me on this. Give it a try. Can you please share what's the exact problem you are facing so that we can discuss a little bit more in detail so that you can proceed further with your work. Worked as SAS Developer, Database Administrator, Query optimizer and Data analyst. Hoping for your reply. Prateek Goyal +91-7859911131,+91-9643338925 +91-9225419302 (WhatsApp) INDIA
$30 AUD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$35 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
on time delivery
$66 AUD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera INDIA
Faridabad, India
4,9
150
Memverifikasi Metode pembayaran
Anggota sejak Feb 21, 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.