When that happens, I stop working.

Least

What are you checking? Why do you need it to be recursive?

Y.B. (10/11/2016)

---

Ok, I think I might be going crazy but I've never seem to have any issues with html encoding when posting code before. However, for some reason I'm...

There's not enough information to give an accurate response, check the following that might help.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Why do you think that converting to nvarchar will make things better?

What type is DateReceived in Reassessments table?

Are you storing time in DateReceived? '2016-10-11' is not the same as '2016-10-11...

John Hick-456673 (10/10/2016)

---

No, I understand the problem and I have seen this solution before.

Uncommenting the loop returned the same results because the loop is supposed to run only...

Square

hjp (10/10/2016)

---

Luis, one question to your solution: Isn't it "unsafe" to rely on @@ROWCOUNT?

I experimented with this sort of code in the summer, but settled for a different approach due...

This might be is simpler.

DECLARE @INPUT_STR VARCHAR(1024) = '\\cc0dware01\BMF\RMS\REBATERATES-WORKING-2016ToEnd08-20160905180112.csv';

SELECT SUBSTRING( @INPUT_STR, LEN( @INPUT_STR) - 17, 14);

I wonder what are the varying parts of the file path. Is it only the...

I'm sorry, it's not intended...

Yes, every bit of additional work will make the solutions slower. But if it makes...

You might...

Can you show me what do you mean with some code? I'm not sure what you...

I just saw the theory that...