If the table has spatial index ,  SQL use it. (check if inside the box)

DECLARE @pnt geometry, @crcl geometry;
DECLARE @dis float = 10000;

SET @pnt = geometry::Point(210000, 700000,...

You do not need to use CAST twice!

SELECT ISNULL(TRY_CAST(Myval AS INT), -1) FROM CastTest;

should be

Is it started around 2017-04-11?
In my system some of the reports take long long time and sometimes ended with timeout.
I  suspect that some hidden updates of Microsoft are...

Why not to use CLR aggregate function that you can download from:

http://msftengprodsamples.codeplex.com/wikipage?title=SS2008%21String%20Split%20Table-Valued%20Function%20%28TVF%29&referringTitle=Home

Izhar Azati

Try:

SELECT * FROM #product

WHERE ','+catid+',' like '%,1,%'

Try:

SELECT

30.AString

,50.E-3AnotherString

,10.E0SomethingElse

into dbo.TempTable;

select * from dbo.TempTable;

You can see that SQL try to parse the number till the not numeric character and then take...

My solution was to loop the files (directory), copy (move) the file to fix temp directory and fix name, do the job, move (delete) the file to archive directory.

Izhar Azati

The 5 lines can by also in the middle of the file!!