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
[login to view URL]
"you got it"
"date de creation"
You will have 2 matches
Table1 row 2 your output will be: "BB"
Table1 row 3 your output will be "AA"
11 freelancere byder i gennemsnit $135 timen for dette job
I can efficiently and qualitatively create described function because I am Senior MS SQL Developer having more than 10 years length of time professionally worked in database design and implementation.