TSQL Challenge 69 - Find the most relevant advertisement based on keywords

Getting Started with Adobe After Effects - Part 6: Motion Blur

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

TSQL Challenges


Subscribe By Email

Pushing database changes needn't be hard work with SQL Compare

Previous Challenges

Top Winners

	leszek_g	232
	Stefan_G	176
	dishdy	106
	malpashaa	101
	Mark	86
View all

Early Review Team

TSQL Challenges Team

	Jacob Sebastian
	Rui Carvalho
	Brad Schulz
	Vijaya Krishna Kadiyala
	Barbarin David
	Peter Larsson
	Mangal Pardeshi
	Alejandro Messa
	Adam Haines
	Rob Farley

TSQL Challenge 69 - Find the most relevant advertisement based on keywords – Part 2

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.

This challenge is Version 2 of the TSQL Challenge 66. This version needs to look at the position of the keyword to decide the importance of that keyword. So a page with keywords: "Backup, Compression, SQL Server" should assign a higher relevance to an advertisement having "Compression, Backup" than "SQL Server, Compression".

http://beyondrelational.com/puzzles/challenges/103/find-the-most-relevant-advertisement-based-on-keywords-part-2.aspx