Đã Đóng

Make this SQL query faster

I am using SQL Server 2019

I have an SQL query

it takes more than an hour to finish

a friend told me this can be improved significantly and finish this query in a few minutes.

The query and tables files are in the attachment

files end with csv should become a table in SQL

there is a function called Dist()

and query called [login to view URL]

just make an offer if you really can improve significantly and tell me what is the time it will take to run the query

Kĩ năng: SQL, Microsoft SQL Server, Quản trị cơ sở dữ liệu

Về khách hàng:
( 5 nhận xét ) Craigieburn, Saudi Arabia

ID dự án: #33732811

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

(131 Nhận xét)
(65 Nhận xét)
(7 Nhận xét)
(35 Nhận xét)
(21 Nhận xét)

I have around 12+ years of professional experience in sql development in oracle/Db2/mysql/sqlserver. I have worked in more than 300 projects. Lets discuss your requirements

$20 AUD trong 1 ngày
(20 Nhận xét)

Hi, i have checked your query and data files you have provided. There is good scope for improvement and i can provide the details in chat. Please ping me.

$25 AUD trong 1 ngày
(33 Nhận xét)

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 a Thêm

$25 AUD trong 1 ngày
(11 Nhận xét)

I can do this job in 1 day. I am a well-experienced SQL TSQL developer. I have read your project description with great interests, so that I feel 100% sure on it. I promise A+. I can get started right now and keep you Thêm

$30 AUD trong 7 ngày
(6 Nhận xét)

I have more than 12 years of experience in Oracle/ SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I hav Thêm

$30 AUD trong 1 ngày
(7 Nhận xét)

Hi , After reading listed requirements in details, I am placing my bid . Let me know If I can help you. I will summarize all the requirements and will provide you with quality notes. I am a ASP.NET ,.NET Core, .NET Thêm

$20 AUD trong 7 ngày
(2 Nhận xét)
(2 Nhận xét)

Hi, I've read your description carefully. I have full experience with sql server. I've also worked on several similar projects. So I can complete your project with high quality on time. Looking forward to hear more abo Thêm

$150 AUD trong 1 ngày
(0 Nhận xét)

I have over 10 years of experience in databases and work with big data architectures. I'm the best for this job.

$20 AUD trong 7 ngày
(0 Nhận xét)

Hi I can upload your commands faster to sql server using SSIS I tried to upload in less than a minute. If you want to know more, you can talk to me. I did your file. Best Regard, Murtaz Kumaritashvili

$15 AUD trong 1 ngày
(0 Nhận xét)

I have developed a number of complicated projects related with all of my above mentioned expertise and won the trust of all of my [login to view URL],I have worked on a number of built-in WordPress plugins & API’s and can man Thêm

$69 AUD trong 1 ngày
(0 Nhận xét)

Greetings I have worked remotely and I have worked with personal projects with Java and building Web Applications with Spring Boot framework. Also, I have worked with HTML/HTML5, CSS, JavaScript, PHP and MySql/Sql da Thêm

$20 AUD trong 7 ngày
(0 Nhận xét)

I AM Working With MS SQL Database Last 4 Years..... You Need Use STORE PROCEDURE For Solved Your Problem..

$20 AUD trong 7 ngày
(0 Nhận xét)
(0 Nhận xét)

Hi Arvind three, I read your job description. I will do your application and provide sufficient work within your estimated. I have 10+ years experience in asp. Net technology. I have last 5 years to work with. Net cor Thêm

$20 AUD trong 7 ngày
(0 Nhận xét)