set @myCursor = cursor for
    select Col3 from Case4_TableA
    where Col2 is not null;

set @query = 'cursor for
    select Col3 from Case + ' @caseID + '_TableA
    where Col2 is not null';
exec @myCursor = @query

• tKeyword: Contains a list of keywords that must be identified in the document text table (tDocText). Has status column (called font=Courier New]status[/font=Courier New]) that needs to be updated upon successful processing.


• tDocs: A table that holds information (attributes and metadata) about documents. One of its columns is updated. We'll call this column attribute1 and it is an ntext datatype. This column may hold zero or more values with each value delimited by HTML-style tags. For example: <tag>Val1</tag> <tag>Val2</tag>


• tTextDocs: A table that holds the text (OCR) of the documents listed in tDocs. The text is held in an ntext column (called theText). In this problem, this table is only read from.


• tDocs_attribute1: This table holds an entry for every value in the docAttribute1 column of the tDocs table. Its columns are DocID, SequenceNumber, Term. TableFk is the reference to the entry in the tDocs table; SequenceNumber is the zero-based number of the value in the docAttribute1 column; and Term is the value (eg, Val1) in the column. However, in this Term column, the value is not delimited by tags.

tKeyword
id  keyword  status
 1  FooBar   {null}
 2  George   {null}
 3  Frank    {null}
tDocs
id  title             attribute1
10  Meeting Minutes   <tag>FooBar</tag> <tag>George</tag> <tag>Frank</tag>
11  Sales call notes  {null} 
12  Project Proposal  {null} 
tTextDocs
id docID  theText
20  10    '16 November 2007 Project FooBar Meeting In attendance...'
21  11    '16 November 2007 Called Company XYZ to discuss...'
22  12    '16 November 2007 Project Proposal Our company is...'
tDocs_attribute1
docID seqNum Term
 10    0     FooBar
 10    1     George
 10    2     Frank

/*
-- Create Function to add the keywords to the attribute line
CREATE FUNCTION dbo.ConcatKeywords(@DocID int)
RETURNS VARCHAR(8000)
AS
BEGIN
	DECLARE @Output VARCHAR(8000)
	SET @Output = ''
	SELECT @Output = '<tag>' + b.Term + '</tag>'
	FROM TDocs_Attribute1 a
	WHERE a.DocID = @DocID
	ORDER BY a.SeqNum

	RETURN @Output
END
*/

/*Below will add every keyword that exists for a particular docID into TDocs_Attribute1.

Note: you may want to add a where clause below to filter to make sure that keyword wasn't already added from a previous run.
*/

Insert Into TDocs_Attribute1(
								 DocID
								,Term
								,SeqNum
							)
Select	 a.DocID
		,b.KeyWord
		,Coalesce((select count(*) from TDocs_attribute1 aa where aa.DocID = a.DocID),0) + Row_Number() over (Partition by a.DocID order by b.id) - 1
from 
	tTextDocs a
inner join
	tKeyWord b
on  a.TheText like '%' + b.Keyword + '%'


--Updates all the DocID attributes using the function you created
Update a
set a.Attribute = dbo.ConcatKeywords(a.ID)
From 
	tDocs a