Noel, I wonder, what if database schema is changed?

New column added, datatype for the column is changed, new table(s)/view(s)/procedure(s) created.

As far as I know this will not be picked up...

Third time.

Especially for idiots.

1) The way TR rounds 0.1250 shows that it takes 0.1250 as > 0.1250(0);

2) The way TR rounds 0.1249 shows that it takes 0.1249 as 0.1250(0)...

Joe, as far as it's described it's not your problem.

The file you've got is built not according to tab-delimited text file specification.

The thing is building those files is faulty and...

Playing idiot?

Or no need to play?

Sorry, it was yours.

So, what is your way to supply 1/3 to BR function?

As a decimal with at least the precision of the input datatype

Which is correct representation of 1/3:

money...

INNER JOIN @Raw R2 ON R1.ID + N - 1 = R2.ID

WHERE R1.ID % (@NthRow-1) = 0

as far as I know the only way to accurately define 1/3 other than a fraction is to store the decimal,fractional and period to define it, but I know of...

SELECT R1.LastName, R2.LastName

FROM @Raw R1

INNER JOIN @Raw R2 ON R1.ID + 1 = R2.ID

WHERE R1.ID % @NthRow = 0

David,

Still waiting for you to show the way you can supply 1/3 to the function.

Concentrate, please. Don't be distracted.

Does it matter?

The question was if EXISTS and NOT EXISTS are equivalent.

The answer does not depend on sargability of EXISTS.

Heh,

There is no "NOT EXISTS".

There is "EXISTS" and "NOT" which reverse boolean result of "EXISTS".

What "not sargable" could appear in reversing boolean value?

David, I see it's your rule - don't believe in facts if they contradict your believes.

Acceptable for a priest, not good for a scientist.

Noel, here is your "lack of knowledge"

We experienced failure of subset of databases, not all of them.

When functionality of primary server was restored...

Translation:

"No! No!!! I not gonna admit!"

What else you need to prove after I proved that TR is based on assumption that trailing digits beyond precision are anything but "all zeros"?

Chris, look at your watches at noon.

What do you see?

Now, who is the rubbish - you or your watches?

Or the definitions on the cite?

12am and 12pm notation exist much longer...