Fermé

SQL Query to Clean Some Data -- 2

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.

Compétences : MySQL, SQL

en voir plus : data retrieve webpage database sql, free data minin gproject sites sql sharpc net, dnn query sql, mysql, sql, php html query sql, data base clean wordpress, uusing data adaptor aspnet query sql server database, parent child query sql server, store form data sharepoint 2007 site sql server, net query sql mobile table example, parent child query sql, query sql 2005 csv, upload data using tab delimited sql plus, query sql parent child result set

Concernant l'employeur :
( 286 commentaires ) Faridabad, India

Nº du projet : #11267016

16 freelances font une offre moyenne de 72 $ pour ce travail

mahmoudgamal008

I have more than 5 years of experience in SQL and MySQL queries. I have more than 1800 answers in Stackoverflow(Q&A Site) [login to view URL] With my knowledge and background, I am Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(39 Commentaires)
5.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(55 Commentaires)
5.2
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(2 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(4 Commentaires)
2.9
ZishanChuhan

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(4 Commentaires)
2.6
owenzhu

good at SQL

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(1 Évaluation)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
technobytes9

extensive mysql knowledge. will deliver in 1 day

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
rameswar1991

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(0 Commentaires)
0.0