Parse SQL Queries - Extract Join Criteria

В работе Опубликован 2 мес. назад Оплачивается при доставке
В работе Оплачивается при доставке

Sql Query Parse Join Columns.

I need a way to parse sql queries and build a list of [login to view URL] used in the join criteria.

1-Needs to be able to paste text (queries) in a textbox or load from a file. They can be many stacked in one file.

2-It needs to extract the join criteria from the queries.

3-It needs to format in a tab delimited file.

+Tabe delimited.

+Schema and table name written out (not alias) and combined.

4-If there are more than 1 criteria between 2 tables (meaning joining on more than 1 column), they both need to be listed and have a unique group number associated (that does not exist in the output file).

5-If the join is between a nested query (a derived table), that join does not need to be included. Only table to table.

6-The output file can not have duplicates across all columns.

It needs to be written in VB.NET 4.7+ Winforms Application.

You can use [login to view URL] library (they have trial) to do the parsing if needed.

It needs to be extremely accurate and smooth with good code.

Attached is an example and output format.

Max bid: 70

When submit bid, please answer: what day of the week is it? (to filter out fake bot bids!)

SQL Программирование на C# VB.NET

ID проекта: #37222441

О проекте

22 заявок(-ки) Удаленный проект Последняя активность 2 мес. назад

Поручен:

LudovicoDT

Hello, it's thursday over here but probably still monday in the US. I'd like to work on this project if you want me to. I would write everything from scratch if I am able to parse the queries correctly. Let me know if Больше

$60 USD за 2 дней(-я)
(2 отзывов(-а))
1.4

22 фрилансеров(-а) готовы выполнить эту работу в среднем за $127

vladang

Hello... Today is Saturday. I can help you with your task. Please, provide more info so we can agree about details. Regards Vladimir

$70 USD за 7 дней(-я)
(186 отзывов(-а))
6.9
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Больше

$180 USD за 3 дней(-я)
(42 отзывов(-а))
6.2
goswamiarpit475

Hello, Today is Saturday. I have checkes the details and attached file. I am sure that i can build a sql parser to extract join tables and other criteria as per sample file. I have 10+years of experience in vb.net, c Больше

$70 USD за 7 дней(-я)
(53 отзывов(-а))
5.9
AbdulBasitAli045

Dear Client. When it comes to your project, I am expert. I will provide you with 100% satisfaction with work and full service. It would be great if you hire me. Based on your feedback, I can draft my proposal accur Больше

$85 USD за 1 день
(136 отзывов(-а))
6.0
rashidamjad

Hi there, I am thrilled to express my interest in your Parse SQL Queries - Extract Join Criteria project. Leveraging a rich background spanning 4-5 years in C# Programming, VB.NET and SQL, I am well-equipped to bring Больше

$250 USD за 8 дней(-я)
(10 отзывов(-а))
4.6
mohjib092

Hi there, Certified Here I have read the project and just checked txt file I will profile you quality work on time Can you please come to the chat box so we can easily discuss in details Thank You Regards, Muhamm Больше

$180 USD за 1 день
(10 отзывов(-а))
4.3
Techalchemy

Hi Sir, As a highly skilled and experienced, I am confident that I can provide the high-quality work you need, but i have some doubts regarding the same, lets discuss in detail make it clear & then i am ready to start Больше

$140 USD за 7 дней(-я)
(5 отзывов(-а))
4.1
Dhawan8787

Hi there! I'm excited about your project and confident in my ability to deliver your project . I'm committed to exceeding your expectations and ready to start from right away . Let's connect and discuss the next steps! Больше

$140 USD за 7 дней(-я)
(7 отзывов(-а))
4.1
ashrafsbai6655

Hi there, I checked your requirements and guarantee you that i have relevant experience in SQL it's gonna be done within the next few hours . Let's contact via chat so that I can start work immediately

$70 USD за 1 день
(8 отзывов(-а))
3.5
ITMed

Hi there, I am excited to share my expertise and skills in SQL, which I have acquired over the past 3 years. I am confident that I can meet your requirements. I would be delighted to work with you and I look forward to Больше

$140 USD за 1 день
(2 отзывов(-а))
3.0
veselidevelop

❤️Hello, Anthony G.❤️ ✨ FULL STACK DEVELOPER ✨ I am a ⚡creative freelancer⚡ and Since 2012, I am managing Software Development tasks successfully. and I have more than ?10 years of Full stack experience and developme Больше

$250 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
IdeaCentre

Hi! I have read all the provided instructions, and I am the right person to work on this task, I wanted to reach out and see whether the opportunity is still available. As you can see from previous clients I deliver Больше

$140 USD за 7 дней(-я)
(1 отзыв)
0.0
Ivanka240204

Hello, Anthony G. This is Ivanna, a senior web/mobile expert, who has acquired various and perfect skills in building many projects for 7 years. Regarding the technical aspect, I am familiar with VB.NET, SQL and C# Pro Больше

$100 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
johnmccalleydh

HELLO POTENTIAL CLIENT, My name is John and I am a SOFTWARE ARCHITECT I am a FULL STACK DEVELOPER with experience in the following: CSS, HTML, MySQL, VB.NET, Swift, PHP, Linux, Python, Javascript and its extensions( Re Больше

$100 USD за 2 дней(-я)
(0 отзывов(-а))
0.0