SQL Query to Clean Some Data -- 2

Closed Posted 7 years ago Paid on delivery
Closed 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.

MySQL SQL

Project ID: #11267016

About the project

16 proposals Remote project Active 7 years ago

16 freelancers are bidding on average $72 for this job

stylesiva

We don't need temp table or even a mapping table. We will be able to do this with a single CTE (Common table expression) query. I have more than 10+ years experience and have done many SQL queries for various projects More

$85 AUD in 2 days
(2 Reviews)
3.8
w3esolution

I have designed and developed more than 200 websites as of now. I have great expertise in Core PHP, Wordpress ,Magento, Laravel,Codeigniter , Cake PHP, Javascript, Jquery,Ajax, Mysql, HTML5,CSS, Webservices, Linux, A More

$57 AUD in 3 days
(4 Reviews)
2.9
ZishanChuhan

I am expert in SQL , can do the task as per your requirements. .

$50 AUD in 2 days
(4 Reviews)
2.6
owenzhu

good at SQL

$66 AUD in 2 days
(1 Review)
1.8
tovishal2001

Hi there, this is pretty straight-forward 2-loop logic. Give me few hours, i will send this to you by morning then you can see result and decide if it meets ur needs. thanks, - Vishal

$49 AUD in 0 days
(1 Review)
0.8
sharptechnology

Dear Employer, Thank you for this wonderful opportunity. I have excellent experience in Website Designing/Development. I am professional website designer/developer. I have 8 years of experience in this field and More

$30 AUD in 3 days
(0 Reviews)
0.0
sanjeevkalkhuria

I have a 6+ Year experience in sql server. and if you agree then it is my first project through freelancer. i have depth knowledge of sql so you can share you enquiry through chat in gmail mail or whatsapp. my mobile More

$35 AUD in 2 days
(0 Reviews)
0.0
VGTGroup

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. Cr More

$66 AUD in 3 days
(0 Reviews)
0.0
javaconnect

Hello! I am an experienced Java developer. I am sure I can work for you and you won't regret it! Please consider my bid

$155 AUD in 3 days
(0 Reviews)
0.0
technobytes9

extensive mysql knowledge. will deliver in 1 day

$111 AUD in 1 day
(0 Reviews)
0.0
rameswar1991

A proposal has not yet been provided

$155 AUD in 3 days
(0 Reviews)
0.0
kmickey34

because I'm an Etl developer and get to see these kind off scenarios daily .Moreover the most important part is tuning,so I can get you the most fine tuned query.

$60 AUD in 2 days
(0 Reviews)
0.0
ksharmila17

Hi, I am sharmila, I have gone through your requirement of writing the query. I am very much interested to work on your project. So please if my understanding of the requirement is correct: CSOP-- Information Techno More

$30 AUD in 1 day
(0 Reviews)
0.0
vw1628189vw

Hi, I was previously working as System Analyst for various companies and have over 6 years experience handling various Databases and creating various scripts in Shell e.g scheduling cron jobs for automation of various More

$40 AUD in 0 days
(0 Reviews)
0.0