Find Jobs
Hire Freelancers

Simple T-SQL queries for Data copying and cleanup

$15-25 USD / hour

Closed
Posted over 4 years ago

$15-25 USD / hour

Azure SQL Database. Connection string and credentials will be provided when hired. As well as a discussion of the details. I have a restaurant app that has menus and products that need to be cleaned up. There are many products that only have a few fields filed in and no related records. I would like to copy from the few records that I have where all the details are completed. After writing the basic scripts, they should be run against many items in the database. Typical copy script will have approximately 5 tables and not more than 100 fields. You must be able to look at data to see how it can be best organized. This is simple T-SQL but it requires data intelligence to understand what needs to be copied where. Tiny database (hundreds of rows) less than 40 tables. Additional T-SQL scripts for importing data and other tasks will be needed I suspect this is a short job, but if the job is done well. there will be opportunity for more work in the future. I know T-SQL, I just have not had the time to get it done. The person selected, if a great job is done, may also get an opportunity to work on some significant reporting, data migration and integration work coming in the soon (days to weeks).
Project ID: 23451704

About the project

39 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
39 freelancers are bidding on average $21 USD/hour for this job
User Avatar
i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
$15 USD in 40 days
4.9 (43 reviews)
5.7
5.7
User Avatar
Hello, I can help you to create T-SQL queries for Data copying and cleanup I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$20 USD in 40 days
5.0 (13 reviews)
5.6
5.6
User Avatar
Hello! I am a Computer Engineer, MBA, MCSA SQL Server, and MCSE Data Mgmt and Analytics, with 14 years of experience in Data Engineering projects and tasks. I am a near-native English speaker, currently available, and results-oriented. I have plenty of experience working with Azure and T-SQL, including reporting, migrations and optimization. I can provide you with valuable information, experiences and best practices regarding Azure and SQL. Also, I have plenty of experience writing SQL code. I can help you writing robust, efficient, and easy-to-understand SQL code. We can discuss details over chat if you need it. Thanks! Sergio
$25 USD in 40 days
4.9 (22 reviews)
5.5
5.5
User Avatar
Hi there, I am interested in your project. This is what I understand from the project description: You have a separate database of products with complete details; and There is a restaurant app with a separate database So you wanted to run a matching of your database against the app database. And the end result will be is the app database will contain data from your database. Please let me know if my understanding is correct. Thanks, Danniel F.
$15 USD in 40 days
4.9 (62 reviews)
5.1
5.1
User Avatar
Proposal - I have gone through your project details. You can expect any kind of work on SQL/SSIS/SSRS from me. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$20 USD in 40 days
5.0 (29 reviews)
4.9
4.9
User Avatar
Hi, My name is Ali and I can work on it with immediate availability. You said rightly that it is small job but technical and delicate and I am expert in this kind of work. Let's have quick discussion so I can work on it.
$20 USD in 40 days
5.0 (33 reviews)
4.9
4.9
User Avatar
Hi, I am very interested to work on your project. I have 17+ years experience in Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobile development, web design, development tools. There are more then 1000 projects(small/medium/high complexity) successfully implemented and few of them related with yours can be seen on my freelancer.com portfolio. * * Note that my bid is relative and will be adjusted after detailed estimation of implementation effort/coast ** Let's start our collaboration by sending me all details in a written document which will be used as reference during project implementation Thank you! AdiC
$27 USD in 40 days
5.0 (2 reviews)
3.6
3.6
User Avatar
I am interested in this project. I have plenty of experience working with data and database table structure. I'd like to discuss this project with you. Thanks!
$22 USD in 40 days
5.0 (4 reviews)
3.5
3.5
User Avatar
Hi. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I have attached my profile.  I am immediate available to join. Thanks Anil Patel
$16 USD in 40 days
5.0 (5 reviews)
3.3
3.3
User Avatar
Hi,I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker
$15 USD in 40 days
5.0 (5 reviews)
3.5
3.5
User Avatar
Hi, I am proffessional developer with 8+ years experience in SQL, I have Microsoft SQL Certificate and also have experience with Azure
$22 USD in 20 days
5.0 (2 reviews)
3.4
3.4
User Avatar
Hi, I am a SQL developer and BI specialist with over a decade in the industry. I can assist you with your queries and design of the underlying data structures. please let me know if you require my assistance. kind regards, Tom.
$16 USD in 40 days
5.0 (3 reviews)
2.9
2.9
User Avatar
hi i have reviwed your project description. i have 12 years experience in sql server quries. message me for further discussion
$22 USD in 30 days
5.0 (1 review)
2.4
2.4
User Avatar
Hello, I read your project description and understand all. I have 20 years in Database development, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, and MS SQL server I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.
$15 USD in 40 days
5.0 (3 reviews)
2.3
2.3
User Avatar
Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 15 yrs of experience in Web and Windows development and Mobile development using ASP.Net, C#, WPF, SQL server, Xamarin, WebAPI, VB6, ASP , XML, Cr Reports etc. I have 4 years experience as well in remote working (as freelancer) for Overseas clients. Please feel free to contact me. Thanks
$20 USD in 40 days
5.0 (4 reviews)
2.1
2.1
User Avatar
Hi I have 5+ years of experience in working with Oracle\PL SQL and also 4+ years of experience in working with Mssql. I think I can to make it.
$20 USD in 40 days
5.0 (1 review)
1.0
1.0
User Avatar
Hi, I am a Bangladesh based freelancer. I am working in ERP industry for almost 4 years. So these types of requirements are very common for us. Let me know, if you need my assistance. Regards- N. A. Nahin
$16 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have reviewed your project posting, seems to be an easy job and would be much more interested in long term association with you. Looking forward to hear from you soon. Regards
$15 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Im a dba and I worked previosly on Data warehouse, BI and analytics teams. Right now Im working with sql server and AWS
$15 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am data analyst in one of reputed bank in india and 8 year's of experience in SQL server. I can help you easily and shortly..
$16 USD in 21 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Lakeville, United States
5.0
3
Payment method verified
Member since Dec 18, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.