Nice and easy thank you.

+1

If the banker's rule was involved, then the code below should return 3.4 and 3.6 - instead, it returned 3.5 and 3.5.

declare @x float, @y float;

set @x = 3.45;

set @y...

The banker's rounding rule is completely unrelated to today's question. What you see in this question is that float cannot represent the .65 fraction in a finite amount of binary...

Thanks for this question. I always hated/never understood this banker's rounding rule. As you can see from this post it is not just in Sql

Banker's Rounding

Stack Overflow

Like others...

The first argument is an expression where those unbound column names refer to the row that leads the current row by the number which the second argument evaluates to....

L' Eomot Inversé (11/12/2012)

---

mbova407 (11/12/2012)

---

Thanks for the question

Will someone please explain example C in english

CREATE TABLE T (a int, b int, c int);

GO

INSERT INTO T VALUES (1, 1, -3),...

Thanks for the question

Will someone please explain example C in english

CREATE TABLE T (a int, b int, c int);

GO

INSERT INTO T VALUES (1, 1, -3), (2, 2, 4), (3,...

The harm is that this website is now in danger of being the target of legal action. When I though it was just the example (and not the "explanation" as...

The example was taken directly from Books Online (August 2008)

When the expression exceeds the specified length, the string returns ** for the specified length.

Copy Code

SELECT STR(123.45, 2,...

Thanks Easy Question.

Good question, thanks for the point.

I guess I don't understand the question. How is using cross-apply with a where join any different then an inner join with the ON (or where) join

SELECT

...

Nice question, I knew that one from experience :blush:

So simple it was scary.... Where is the catch, the typo, the misguided reference?

Thanks for the question.