my solution

The solution is based mainly on split / concatenate of strings using T-SQL XML functions.

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.