Write an SQL Query to Clean Some Data
$30-250 USD
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: #11266845
About the project
22 freelancers are bidding on average $147 for this job
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had More
Hello, I have read your project description about Database Design and I would appreciate if you can open discussion with me and I see how we can work together. Am a graduate in Computer Science and have already desig More
I have experienced in SQL administration, design and manipulation for more than 6 years. I successfully design and implement the databases for a transportation system, a bus system, and many other systems. I believe I More
Ready to work right now. I have check it...i will do query for clean data. I will take charge $40 for your project. Thanks, Kishan
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 qu More
Hello, I can do this for you in 3-5 days. i work for a corporate and create the queries every day. Let me know if i can do this for you.
I have deep experience with respective to DATA MANAGEMENT, DATA TRANSFORMATION, DATA PROCESSING AND DATA STORAGE & Etc with various types of database systems like SQL Server, My Sql, Oracle and many. I can promise y More