SQL Query to Clean Some Data -- 2
$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.
Project ID: #11267016
About the project
16 freelancers are bidding on average $72 for this job
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
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
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
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
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
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.
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
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