I think a good use of INTERSECT and EXCEPT is when you need to compare many fields. It is much quicker than writing a join or where exists on...

Thanks for the suggestion. I solved it by using a table valued function and a cross apply with table that had the values I wanted searched.

For the sake of this example Addresses has 1 column, Address1, and SearchWords has 1 column, Words. I want to use the Words column to to do a full...

It returns incorrect syntax. I believe it is populated because the following works fine.

SELECT Address_1

FROM Addresses ad

WHERE CONTAINS(ad.Address_1, 'bike')

I added a case statement and it worked.

WITH MaxDtCTE (RunId, ObservationDate) AS

(

SELECT RunId,

CASE WHEN ISDATE([Value]) = 1 THEN CONVERT(datetime, [Value]) ELSE NULL END

FROM tmp_TestTable

WHERE ISDATE([Value]) = 1

AND [Value] IS...