And I don't change any rules.

I just try to make you follow your own rules.

Was it you who told about precise numbers to be supplied to BR?

No?

Did you support this...

Isn't double precision a synonym of float?

Do you use actually use double precision in the function?

Did your mama tell you not to lie?

Float is the best datatype for calculations because it provides the most precise outcome.

In that example error brought by float calculations is less than float precision - 15 digits.

It does...

You don't use float in your function.

Right?

Because it's imprecise.

So, please use datatypes you're using for your function.

For up-to-date results you need to use:

@command1 = 'sp_spaceused ''?'', ''true'''

You passed what?

@Pass1?

Right.

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

2.2650000000000001

That's the fact.

You just failed to assign desired value to the variable.

It has nothing to do...

> If you pass .666 (which is obviously not the same thing as 2/3) to BR,

So, what I need to pass to pass 2/3?

Which value accepted by BR...

> Then explain to me how I was able to perform the calculation "2/3 * 3" and end up with "2", which you claimed wouldn't happen.

For those who did...

They actually pay someone else to round down your minutes.

It's you who suppose to place right function on back end to round it up.

Absolutely agree.

They were thinking instead of digging.

You can still type all those dates on a typewriter (if you can find one ), but you...

1) Format datetime using style 120.

2) Replace "-" with "\"

3) Take as many LEFT characters as you need for requested format.

4) Minimal thinking effort is always useful in programming.

a function works with the parameter it receives, not what that value once was somewhere at some time. Period.

And you cannot pass 2/3 to the function.

You cannot do...

It does not affect ROUND function.

ROUND perfectly rounds the value you supplied:

@Pass1 = 2.2650000000000001

ROUND(@Pass1,2) = 2.27.

Absolutely valid result.

Sorry to tell you, but you cannot have absolutely precise numbers in computers.

Every...

...

and a2.full_part = a1.full_part

...

Search this forum for sp_MSforeachtable and sp_spaceused.

BOL may also give you some useful information.