I'm not trying to prove it is invalid.  All rounding methods have some issue some where.  Will you agree with that statement?

I am not proposing that Bankers Rounding be used...

Okay, here is your task:

You have collected 0.50 in taxes from the sale of 1 or more items (doesn't matter how many).  You have to distribute these funds to three...

Your post:

Does the name "Giordano Bruno" say to you anything?

I believe the names "Catholic Church" and "Holy Inquisition" were not less at that times than IBM, IEEE, Microsoft and all...

Sergiy, it was the way you put it, not the way I put it.  As I tell my kids, it is the tone or inclination you put on words as...

I made ONE statement about your personality, I did not continously attack you in post after post, and I even apologized in a private email about that statement (something you...

This:

You should not prove you did not commit a crime.

They must prove you did.

If they cannot provide an evidence - there are no evidences.

This depends on where you are being...

And do you admit that the standard rounding function also fails on occasion (look at my example)?  You would have to apply "some work around to fix its results" (your...

Now i need more info.  DDL for the tables and some sample data plus expected output based on the sample data.

With that, either I or someone else out there will...

>> If you wish to continue the academic argument, please find someone else who is interested in such an argument.

You mean who is smart enough and can understand this...

Actually, this :

You are a brainless moron.

Please don't take it as an insult, it's just an observation on my part.

is an insult no matter how you put it.  I...

I have never resorted to insults (unless you you are meaning my comment about a type a personality, taht was not an insult but an observation on my part), although...

Can't think of why you would want to do that, but if I had a need to do something like that, it really sounds like dynamic sql is the only...

Is this what you are looking for?

CREATE TABLE dbo.table_1(

      id_1  int,

      id_2  int,

      id_3  int)

CREATE TABLE dbo.table_2(

      main_id           int,

      main_desc   varchar(250))

INSERT INTO table_1

VALUES(1, 2, 3)

INSERT INTO table_2 VALUES(1, 'Description 1')

INSERT...

Once we are comfortable with the system performance, I hope to be able to start rolling some out.  We were in a crunch to improve system performance, so had to...

JacekO, thanks for the catch on the missing paren.