Try this instead:


FOR %f IN (\\ServerB\Results\*.Sql) DO @ECHO %f


There are a couple of problems with the original command you had.   The /F option tries...

Most everything I see in your post appears okay, except perhaps the UPDATE.   Seems more appropriate to do it this way:

UPDATE RLC
SET RLC.[ReplTime (Secs)] = DATEDIFF(second,...

Are you sure you want a default value of 0, while having a UNIQUE index on that field?  One insert of a default value and you don't get to repeat...

Have you tested the values that come into play for the %%i variable ?  Also, when the SQL job runs, it will not run under your user id unless that's...

Not sure you need such a column.   All you need in any given query is:


SELECT ROW_NUMBER() OVER(ORDER BY CreatedDate) AS NewIdentityColumn
FROM dbo.YOUR_TABLE
...


Well... no replies...   I'm going to guess there's just no practical way to do it, which is what I suspected all along, but I had to at least ask the...

Just want to know if the following gets the correct result, and if not, what the problem is.

DECLARE @T2 TABLE
(
ID INT IDENTITY(1,1)
,Col1...