Not much difference

DUMP TRAN dbName WITH NO_LOG

GO

CheckPoint

DECLARE @Counter integer

SET @Counter = 1

WHILE @Counter <= 50000 -- 0:00:27 seconds

BEGIN...

Yes - it helped me recognize I am a knucklehead and did not do the simple addition before I posted...  

Try this:...

Is this what you are looking for?  I have removed DISTINCT, (generally that indicates a problem with table relationships and should be avoided...).  Also, the need for an ORDER BY...

What results do you hope to achieve?  The names of your tables seem to indicate that you are summing apples and oranges. 

Does this psuedo code help in giving us...

Cross Post

Wow!  Kinda harsh...   

I am in my busy season, but I still take time to visit this site as often as possible -...

Can you show us some data that does contain that string?  For my little test, it does work.

DECLARE @WordSearch TABLE( Word varchar(100))

INSERT INTO @WordSearch

SELECT 'This string has...

I just checked, (was busy with someone else's crisis) and in the words of Ed MacMann (sp) from the Johnny Carson "Tonigh Show"

"You are correct, sir!"  I did have...

Sorry I missed that - good catch.  (although, this is somewhat recursive, so I am not sure it will have an adverse impact...  dunno and haven't tested it)

The parse string...

I would suggest a different avenue. 

Here is parse function that will strip your keywords out into a table, (you can change the length to whatever your needs may warrant). ...

It might be easier to use the ASCII character set from 49 to 57.  Look up function ASCII().  You may need to use this in conjunction with PATINDEX(). 

ISNUMERIC is not always reliable.  I would suggest you do a search on that within this site. 

Try the following:

SELECT ISNUMERIC( 1)

SELECT ISNUMERIC( 'A')

SELECT ISNUMERIC( '-')

I did initially try this as a loop - old habits are hard to break...  The function was not in the posting and I felt reasonably good about that sucker...  ...

That's quite the left-handed compliment...  (Where did I find that here?) 

We have that issue with information pasted into our web pages and then that information needs to be copied, (and altered) into our SPs. 

We created a table and function...