Write an SQL Query to Clean Some Data
$30-250 USD
Kiszállításkor fizetve
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.
Projektazonosító: #11266845
A projektről
22 szabadúszó tett átlagosan 147$ összegű árajánlatot erre a munkára
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 Továbbiak
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 Továbbiak
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 Továbbiak
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 Továbbiak
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 Továbbiak