Đã Đóng

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

Kĩ năng: MySQL, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 150 nhận xét ) Faridabad, India

ID dự án: #11266995

21 freelancer chào giá trung bình$74 cho công việc này

$111 AUD trong 3 ngày
(28 Nhận xét)
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 Thêm

$60 AUD trong 2 ngày
(15 Nhận xét)
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 Thêm

$60 AUD trong 1 ngày
(4 Nhận xét)
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 Thêm

$60 AUD trong 3 ngày
(1 Nhận xét)
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 Thêm

$77 AUD trong 4 ngày
(6 Nhận xét)
3.1
owenzhu

SQL professional

$66 AUD trong 3 ngày
(1 Nhận xét)
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 Thêm

$35 AUD trong 2 ngày
(1 Nhận xét)
0.7
ghadasamir89

A proposal has not yet been provided

$35 AUD trong 1 ngày
(0 Nhận xét)
0.0
$155 AUD trong 3 ngày
(0 Nhận xét)
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 Thêm

$30 AUD trong 2 ngày
(0 Nhận xét)
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 trong 0 ngày
(0 Nhận xét)
0.0
$100 AUD trong 5 ngày
(0 Nhận xét)
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 Thêm

$66 AUD trong 3 ngày
(0 Nhận xét)
0.0
$155 AUD trong 3 ngày
(0 Nhận xét)
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 Thêm

$45 AUD trong 1 ngày
(0 Nhận xét)
0.0
$155 AUD trong 3 ngày
(0 Nhận xét)
0.0
Sandeep2363

Hi i will prepare query for you

$100 AUD trong 1 ngày
(0 Nhận xét)
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 Thêm

$60 AUD trong 10 ngày
(0 Nhận xét)
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 Thêm

$45 AUD trong 3 ngày
(0 Nhận xét)
0.0
$66 AUD trong 3 ngày
(0 Nhận xét)
0.0