For those interested, I changed the factor parameter to be what you want your figure rounded to, as I was never very happy that you had to pass 2 to...

Is it really a problem???

If you have written a solution, there must have been a problem to start with.

Solutions exist to solve problems, remember?  And lots of people reading these...

Is it really a problem?

Yes.  I have no idea what the real amounts are, but lets play.

Imagine you are in a business that does 1,000,000 cash transaction a week/month/period.

Let suppose...

We do NOT use BR.

I said we have a problem where some depots do not deal in denominations less than 50 pence. At others it's 10 pence.  This saves...

Knowing that, how 1.125 must be rounded to 2 decimal digits?

Well, not the way BR does it.

Why your company have chosen BR for this?

Right, it works for their profits.

It's just...

I was reminded this morning what started this.  i.e. the business requirement.

I work for a large metal re-processing company.  People fetch things into our depots, such as old stainless steel...

Jeff is a smart guy, and he helped me out in this post.

It may not be applicable to the original post, (but...

The procedure breaks but you can actually catch the error and handle as needed, though what you would do at that point is beyond me since we have a serious...

What would you expect this to do?

create procedure TestProcedure @id int

as

BEGIN

 Declare @price int

 SELECT @price = price

 FROM Books

 WHERE  bookid = @id -- Refer...

Some types of error cause immediate termination of a batch

For example referencing a non-existent table returns:

  Server: Msg 208, Level 16, State 1, Line 1 Invalid...

Hello Lynn,

Different time zones, and pressure at work makes 'real-time' communication difficult, but I will try to explain your function to myself in the next couple of days, and let...

I like it too.  All the test examples from the original post work, as does a few of Sergiys numbers I've thrown in.

Now you just have to explain *how* it...

if you go to this link, it seems to suggest that 64 Bit servers don't suffer from this.  Any one got a 64 bit SQL implementation handy?

Hear Hear.  Back to the plot

I've had a look around and found this page contains lots of information, and has lots of links at the bottom to other sites, including...

Him?

Computers are female

The top six reasons computers must be female:

6. As soon as you have one, a better one is just around the corner.

5. No one but the creator understands...