Ditutup

SQL Query to Clean Some Data

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.

Budget --- $ 60

Kemahiran: MySQL, SQL

Lihat lagi: create account number query sql, access create custom query sql, uusing data adaptor aspnet query sql server database, mysql, sql, php sql database create file, click deployment install sql express create database, cms class sql script create php simple page, store form data sharepoint 2007 site sql server, sql server create table graphically cnet dbo, net query sql mobile table example, parent child query sql, sql server create tabel csv file, query sql 2005 csv, upload data using tab delimited sql plus, query sql parent child result set

Tentang Majikan:
( 150 ulasan ) Faridabad, India

ID Projek: #11266995

21 pekerja bebas membida secara purata $74 untuk pekerjaan ini

$111 AUD dalam 3 hari
(28 Ulasan)
4.7
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologie Lagi

$60 AUD dalam 2 hari
(15 Ulasan)
4.2
bhagwansahane89

Come on chat now so we can discuss more....am waiting... I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more Lagi

$60 AUD dalam sehari
(4 Ulasan)
3.3
robertal

Hello there - I am an experienced SQL Developer. This indeed can be done with an explicit mapping table to store the frequency lookups as the first step, which would typically be done with a temporary table. What targe Lagi

$60 AUD dalam 3 hari
(1 Ulasan)
3.0
bhardwajrkay

hello project provider This is Rajesh Bhardwaj. i have 4.5+ year of experiences in web development.. till now i was done 100+ project as a freelancer ..i am interested in your project and want to work with you.. so Lagi

$77 AUD dalam 4 hari
(6 Ulasan)
3.1
owenzhu

SQL professional

$66 AUD dalam 3 hari
(1 Ulasan)
1.8
bhaveshghodasara

Hi, I am working extensively in SQL since last 11 years. I am worked with top IT companies in past. Currently I am working as solution architect for one of the biggest IT company. I have analysed sample data and I Lagi

$35 AUD dalam 2 hari
(1 Ulasan)
0.7
ghadasamir89

A proposal has not yet been provided

$35 AUD dalam sehari
(0 Ulasan)
0.0
$155 AUD dalam 3 hari
(0 Ulasan)
0.0
prtk13061992

Hi, I would like to tell you about myself that I am currently working in INDIA's TOP MNC Software based company. Having 4.5+ yrs of experience in SQL and 3+ yrs experience in SAS . I would like to nominate myself f Lagi

$30 AUD dalam 2 hari
(0 Ulasan)
0.0
vw1628189vw

I already have the query . you can have a look if works for you fine else you always have option to hire anybody. looking forward to your chat. thank you. best regards, Muhammad

$30 AUD dalam 0 hari
(0 Ulasan)
0.0
$100 AUD dalam 5 hari
(0 Ulasan)
0.0
lbarauskas

Will deliver two SQL codes - each will use loops (if this is acceptable from performance perspective) first to loop through blank BBSctr and update with the top BBSctr value for corresponding SpnsrSctr value second Lagi

$66 AUD dalam 3 hari
(0 Ulasan)
0.0
$155 AUD dalam 3 hari
(0 Ulasan)
0.0
onixsuditu

I believe that I am suitable for this job since I have experience with working in SQL databases for 5 years now. I write SQL queries daily and also handle and manipulate data from external tables. In order to complet Lagi

$45 AUD dalam sehari
(0 Ulasan)
0.0
$155 AUD dalam 3 hari
(0 Ulasan)
0.0
Sandeep2363

Hi i will prepare query for you

$100 AUD dalam sehari
(0 Ulasan)
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 Lagi

$60 AUD dalam 10 hari
(0 Ulasan)
0.0
musthafathamyeez

I have 10+ years of experience working design and developing applications of various types and business needs. I have worked with different databases ranging from Oracle, MSSQL, mySQL, NOSQL ( mongoDB, Redis) . My high Lagi

$45 AUD dalam 3 hari
(0 Ulasan)
0.0
$66 AUD dalam 3 hari
(0 Ulasan)
0.0