SP SQL Server - text compare -- 2

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

Hi

We need a SQL Server function to compare to tables and find a match.

The function must have 2 parameters:

1 - [login to view URL] - this is a string

2 - Table2CompareTo - field To Compare To

Table1 will contain a field/string and the purpose of this is to find a string contained in this field

Table2 will have 2 fields

Field1 - fieldtocompareto - you start with first row and search if exist inside table1

Field2 - when you find a match, your output will be the value in field2 and continue with next row in table1

Example

[login to view URL]

"you got it"

"date de creation"

"not existing"

Table2

Field1 Field2

not AA

de BB

You will have 2 matches

Table1 row 2 your output will be: "BB"

Table1 row 3 your output will be "AA"

Thanks

SQL Microsoft SQL Server

Project ID: #29062022

About the project

10 proposals Remote project Active 3 years ago

Awarded to:

vw8193609vw

Hello, I have gone through the requirements and developed POC using Sql stored procedure for your requirement. Please find the POC in the below link [login to view URL] More

$30 USD in 1 day
(1 Review)
1.4

10 freelancers are bidding on average $114 for this job

sumon355

Hello, How are you? I am very interested to make required function. Just I need a short clarification on the requirements. Looking forward to have a positive response from you. Thanks

$90 USD in 1 day
(285 Reviews)
7.8
khaldalfalah

Hi, I am ready to create the needed sql server script to compare these two tables. I have experience in VB.net, MS SQL server, asp.net and crystal reports more than 13 years. Other skills: Access vba, Excel vba, C#, More

$190 USD in 4 days
(17 Reviews)
5.7
Crayon1365

Hello Dear Employer I'm a expert developer and have rich experience in ms sql server, t-sql, writing functions, stored procedures,... I can provide for you a draft if you are agree with my bid Warmest Regards

$90 USD in 1 day
(3 Reviews)
3.9
Webstudi0

Hi there, I have 6+ years experience in MySQL and MS SQL and fluent with most database tasks: - creating databases, tables and views - creating and optimising complex queries, stored procedures, functions and triggers More

$99 USD in 1 day
(1 Review)
0.4
abdelmounaimD

hi there, I am a software engineer experienced in web full-stack development, it happens that I have good experience in sql database managment , that's why I have what it takes to do the job, send me a message if you a More

$100 USD in 1 day
(0 Reviews)
0.0
mobadreldin

Hi, my name is Mostafa. I have a diploma in Business Intelligence Development. I have experience in database design, SSIS, SSAS, SSRS, Power BI, and other BI tools. Could tell me more details about the tables structure More

$150 USD in 3 days
(0 Reviews)
0.0