matching string of one table to substring of another table

Question

question

sql_ibrahim61 asked Oct 8, '16

matching string of one table to substring of another table

![please look at the picture, it has two table and output tabe][1] [1]: /storage/temp/3715-sql1.png

sql-server-2008 sql joins substring string-function

sql1.png (7.8 KiB)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2016-10-10T10:40:35Z

Magnus Ahlkvist answered Oct 10, '16

It's not entirely clear what you have tried so far and how that went... You would want to look at joining Table1 to the result of a call to a SPLIT-function (google for Jeff Moden and Split and you will find some very efficient split-string-functions which you can use), and finally you would want to use XML PATH to get the results in csv format.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question