Implementation is fine for what it was designed for, which is floats, which as both you and I know (it's not like we haven't pointed it out repeatedly), is the...

This is easy. The exact number 612.945, if followed by no non-zero digits, should round down to 612.94. The number that the function received in the tests was actually 612.94500000000005, which should round...

We all agree. The rules have been laid out exactly, and no one other than you disagrees with them.

"So, you're wrong.

It his words, not mine!"

And I quote you again....

,@pass6 = 612.945 -- should return 612.94

,@pass7 = 5.025000000000 -- should return 5.02

...which is incorrect, since the function doesn't actually receive...

No, because as Sergiy told us that number isn't what actually gets passed to the function, and as he also told us, that's not a problem with the function, but...

"For those who did not perform well in school I explain:

"/" and "*" have the same priority. So, it may be executed in any order.

If you write 2/3*3 it does...

"You passed what?

@Pass1?

Right.

What is the value @Pass1 at the moment you passed it to ROUND?

2.2650000000000001

That's the fact."

Thank you, thank you, thank you. You just proved that the FN_BRound function performs...

No, the value I passed was "2.2649999999999999999999999999999999999" (it's right there in the code, and really hard to miss), which should round down to 2.26 using the ROUND(x,2) function, but instead rounds...

"And you cannot pass 2/3 to the function.

You cannot do it in any computer system. Using any computer language."

Then explain to me how I was able to perform the calculation "2/3 *...

In which case the LEFT OUTER JOIN should return a null value for the right hand side. While I don't have test data from you, so I haven't tested it,...

Damn, but you're a thread shitter. Oh, your test doesn't work.

Now, with that said...

David Jackson, while the problem isn't your's, but SQL Server's, I'm thinking my original concept of having...

"And I'm thrilled to know about environment you were performing your test.

Really.

Because in my environment (SQL2000 Query Analyzer)

select (2./3)*3

returns 1.999998."

I told you which environment I ran it in, VB.Net 2003,...

"After taking a course take a training in reading and read this topic.

At least one person indicated agreement with my position.

Can give you a hint: it was right after "2/3"...

Is this what you are looking for?

SELECT

 a1.people_code_id

 ,a1.academic_year

 ,a1.academic_term

 ,a1.academic_session

FROM

 academic a1

 LEFT OUTER JOIN academic a2 ON

  a1.people_code_id = a2.people_code_id

WHERE

  a1.academic_session = 'main'

 AND a2.academic_session IS Null

Ah, I wasn't even thinking about the fact that each row needs to have multiple datapoints, as I use it where each row represents one value in the chart.

Hmmm, going...