Database Challenges

Here is the logic testing data that we created for TSQL Challenge 17

id   keyword              data
---- -------------------- ----------------------------------------
1    Pet Store            Microsoft SQL Server
2    SQL Server Database  Dinner at a New York Restaurant
3    Restaurant           Welcome to TSQL Challenges 17
4    New York             Bob is a Database Expert
5    TSQL Challenges      Is Microsoft Listening?
6    Microsoft            New Challenges are coming up
7    SQL                  Beyond Relational has a SQL/TSQL Team
8    Join operation       Internal Evaluation Process
9    PASS                 Join Operation in SQL Language
10   '$*;£-+'             Beyond Relational concepts
11   Internal             '$*;£-+' is an extra expression
12   Join                 SSMS is a SQL Server client tool
13   DBCC                 Challenges help learn through play
14   SSMS                 SQL PASS EU is coming soon
15   Challenges           DBCC is an internal SQL Server command
16   NULL                 NULL

Here is the expected results based on the above sample data

id   keyword              data
---- -------------------- ------------------------------------------------------------------------
1    Pet Store            <a href="tsql.com?id=6">Microsoft</a> <a href="tsql.com?id=7">SQL</a> 
							Server
2    SQL Server Database  Dinner at a <a href="tsql.com?id=4">New York</a> <a href="tsql.com?id=3">
                           Restaurant</a>
3    Restaurant           Welcome to <a href="tsql.com?id=5">TSQL Challenges</a> 17
4    New York             Bob is a Database Expert
5    TSQL Challenges      Is <a href="tsql.com?id=6">Microsoft</a> Listening?
6    Microsoft            New <a href="tsql.com?id=15">Challenges</a> are coming up
7    SQL                  Beyond Relational has a SQL/TSQL Team
8    Join operation       <a href="tsql.com?id=11">Internal</a> Evaluation Process
9    PASS                 <a href="tsql.com?id=8">Join Operation</a> 
                           in <a href="tsql.com?id=7">SQL</a> Language
10   '$*;£-+'             Beyond relational concepts
11   Internal             <a href="tsql.com?id=10">'$*;£-+'</a> is an extra expression
12   Join                 <a href="tsql.com?id=14">SSMS</a> is a <a href="tsql.com?id=7">SQL</a> 
                           Server client tool
13   DBCC                 <a href="tsql.com?id=15">Challenges</a> help learn through play
14   SSMS                 <a href="tsql.com?id=7">SQL</a> <a href="tsql.com?id=9">PASS</a> EU is
                           coming soon
15   Challenges           <a href="tsql.com?id=13">DBCC</a> is an <a href="tsql.com?id=11">
                          Internal</a> <a href="tsql.com?id=7">SQL</a> Server Command
16   NULL                 NULL

Here is the TSQL script to create an populate the sample table with data

DECLARE @t TABLE(
	id TINYINT, 
	keyword VARCHAR(20), 
	data VARCHAR(40)
)

INSERT INTO @t(id, keyword, data)
SELECT 1, 'Pet Store', 'Microsoft SQL Server'
UNION ALL
SELECT 2, 'SQL Server Database', 'Dinner at a New York Restaurant'
UNION ALL
SELECT 3, 'Restaurant', 'Welcome to TSQL Challenges 17'
UNION ALL
SELECT 4, 'New York', 'Bob is a Database Expert'
UNION ALL
SELECT 5, 'TSQL Challenges', 'Is Microsoft Listening?'
UNION ALL
SELECT 6, 'Microsoft', 'New Challenges are coming up'
UNION ALL
SELECT 7, 'SQL', 'Beyond Relational has a SQL/TSQL Team'
UNION ALL
SELECT 8, 'Join operation', 'Internal Evaluation Process'
UNION ALL
SELECT 9, 'PASS', 'Join Operation in SQL Language'
UNION ALL
SELECT 10 , '''$*;£-+''', 'Beyond Relational concepts'
UNION ALL
SELECT 11, 'Internal', '''$*;£-+'' is an extra expression'
UNION ALL
SELECT 12, 'Join', 'SSMS is a SQL Server client tool'
UNION ALL
SELECT 13, 'DBCC','Challenges help learn through play'
UNION ALL
SELECT 14, 'SSMS', 'SQL PASS EU is coming soon'
UNION ALL
SELECT 15, 'Challenges','DBCC is an internal SQL Server command'
UNION ALL
SELECT 16, 'NULL',NULL

SELECT * FROM @t