I use this trick - adding e0

For example,

Select ISNUMERIC('10,000')

--> 1

Select Convert(float, '10,000')

-->

Msg 8114, Level 16, State 5, Line 2

Error converting data type varchar to float.

So adding...

I had the same problem. So I've wrote a stored procedure that you can schedule it to run every hour(?) to delte the used file. Hope it can help you.

CREATE...