Simple T-SQL queries for Data copying and cleanup

종료 등록 시간: 4년 전 착불
종료

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).

SQL T-SQL (Transact Structures Query Language) 마이크로소프트 SQL 서버

프로젝트 ID: #23451704

프로젝트 소개

39 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 4년 전

이 일자리에 대한 프리랜서 39 명의 평균 입찰가: $21 (1시간 기준)

sherifamgadnabih

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 / (1시간 기준)
(43 리뷰)
5.7
schoudhary1553

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 기타

$20 USD / (1시간 기준)
(13 리뷰)
5.6
SergioAlfaroV

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 기타

$25 USD / (1시간 기준)
(22 리뷰)
5.5
dvfabia

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 data 기타

$15 USD / (1시간 기준)
(62 리뷰)
5.1
jayantavkumar

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. 기타

$20 USD / (1시간 기준)
(29 리뷰)
4.9
AliSafder

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 o 기타

$20 USD / (1시간 기준)
(33 리뷰)
4.9
adicoman

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, 기타

$27 USD / (1시간 기준)
(2 리뷰)
3.6
vcallegarip

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 / (1시간 기준)
(4 리뷰)
3.5
aap31374

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 기타

$16 USD / (1시간 기준)
(5 리뷰)
3.3
Shakerfawzy

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 ass 기타

$15 USD / (1시간 기준)
(5 리뷰)
3.5
aramgev

Hi, I am proffessional developer with 8+ years experience in SQL, I have Microsoft SQL Certificate and also have experience with Azure

$22 USD / (1시간 기준)
(2 리뷰)
3.4
tomarooks

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 r 기타

$16 USD / (1시간 기준)
(3 리뷰)
2.9
TayyabChishty

hi i have reviwed your project description. i have 12 years experience in sql server quries. message me for further discussion

$22 USD / (1시간 기준)
(1 리뷰)
2.4
NoSonforhim

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 mak 기타

$15 USD / (1시간 기준)
(3 리뷰)
2.3
sahumk2000

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 기타

$20 USD / (1시간 기준)
(4 리뷰)
2.1
imchedlishvili

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 / (1시간 기준)
(1 리뷰)
1.0
nahin2020

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 / (1시간 기준)
(0 리뷰)
0.0
bdmvr

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 / (1시간 기준)
(0 리뷰)
0.0
ferjromero

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 / (1시간 기준)
(0 리뷰)
0.0
mramadass

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 / (1시간 기준)
(0 리뷰)
0.0