Find Jobs
Hire Freelancers

SQL Query to Clean Some Data

$30-250 AUD

クローズ
投稿日: 8年近く前

$30-250 AUD

完了時にお支払い
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
プロジェクト ID: 11266995

プロジェクトについて

21個の提案
リモートプロジェクト
アクティブ 8年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に21人のフリーランサーが、平均$74 AUDで入札しています
ユーザーアバター
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 technologies/languages/database server. - Asp.net,C#.net, MVC - Linq to SQL,Entity Framework - Jquery,AngularJS,NodeJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Web API 2, WCF WebService - Application Security Remediation,Penetration Testing - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are looking for. We can discuss further on chat. Looking forward from your end. Thanks
$60 AUD 2日以内
5.0 (15 レビュー)
4.2
4.2
ユーザーアバター
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 about the project. Regards, Logicmaker
$60 AUD 1日以内
4.5 (4 レビュー)
3.3
3.3
ユーザーアバター
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 please come in chat box for further discussion . Thanks & warm regard Bhardwaj
$77 AUD 4日以内
4.6 (6 レビュー)
3.1
3.1
ユーザーアバター
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 target SQL server is this going to? These steps can be incorporated into a script which will run each of the stages to complete the cleansing on the data. Happy to discuss you needs. /RAL.
$60 AUD 3日以内
5.0 (1 レビュー)
3.0
3.0
ユーザーアバター
SQL professional
$66 AUD 3日以内
5.0 (1 レビュー)
1.8
1.8
ユーザーアバター
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 can clean it using just 1 SQL statement. As it is my first project and first experience with freelancer, I am bidding very low.
$35 AUD 2日以内
5.0 (1 レビュー)
0.7
0.7
ユーザーアバター
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 query for custom results and i think i;m best fit for this. Here, I offer you to give my best output on your all database needs. I’m committed to best quality work with regular updates. You will get your work done before your expectations as I am very strict follow of deadlines. Looking forward to your reply Thank you!
$50 AUD 2日以内
5.0 (1 レビュー)
0.0
0.0
ユーザーアバター
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 highest priority is to understand what the customer requires and deliver the solution within time and budget. I am easy to communicate and always available for discussion. It would be my pleasure to work with you on this project. Cheers.
$45 AUD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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. Creating new database for automatic interactive voice respond (AIVR) with procedures, triggers linked to bank accounts. Also have less expereince with other databases like Oracle, MySQl, SQLlite.
$60 AUD 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi i will prepare query for you
$100 AUD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 complete the request I plan not to create temporary tables, but to create CTEs, which I use frequently, in order to calculate the fields which I need to show. I hope we will collaborate on this project. Regards, Oana
$45 AUD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 to loop remaining blank BBSctr and update with the top BBSctr value for corresponding CnsTckr value
$66 AUD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 0日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 for this job. I just joined the Freelancer so giving offer like free of cost. You can trust me on this. Give it a try. Can you please share what's the exact problem you are facing so that we can discuss a little bit more in detail so that you can proceed further with your work. Worked as SAS Developer, Database Administrator, Query optimizer and Data analyst. Hoping for your reply. Prateek Goyal +91-7859911131,+91-9643338925 +91-9225419302 (WhatsApp) INDIA
$30 AUD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
A proposal has not yet been provided
$35 AUD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
on time delivery
$66 AUD 2日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

INDIAのフラグ
Faridabad, India
4.9
150
お支払い方法確認済み
メンバー登録日:2月 21, 2015

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。