Find Jobs
Hire Freelancers

SQL Query to Clean Some Data

$30-250 AUD

Closed
Posted over 7 years ago

$30-250 AUD

Paid on delivery
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
Project ID: 11266995

About the project

21 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $74 AUD for this job
User Avatar
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 in 2 days
5.0 (15 reviews)
4.2
4.2
User Avatar
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 in 1 day
4.5 (4 reviews)
3.3
3.3
User Avatar
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 in 4 days
4.6 (6 reviews)
3.1
3.1
User Avatar
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 in 3 days
5.0 (1 review)
3.0
3.0
User Avatar
SQL professional
$66 AUD in 3 days
5.0 (1 review)
1.8
1.8
User Avatar
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 in 2 days
5.0 (1 review)
0.7
0.7
User Avatar
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 in 2 days
5.0 (1 review)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi i will prepare query for you
$100 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
on time delivery
$66 AUD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Faridabad, India
4.9
150
Payment method verified
Member since Feb 21, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.