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.
16 freelances font une offre moyenne de 72 $ pour ce travail
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus