|
|
|
Re: calculate the max and sum value by weird way !!! [message #342576 is a reply to message #342575] |
Fri, 22 August 2008 18:45   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Quote: |
Thanks for the explanation, but please provide details on how this addition operation works; as in 1 + 2 = 3.
|
Well, now that you bring it up that has quite a bit of a background story.
In the beginning there was just "nothing" and "something".
That system later got revised into "nothing", 1, 2, 3, "lots".
Since a lot of people had a lot of "nothing" they decided to split that into "null" and "zero" to be able to put it in different bags.
Then they added a lot of numbers in the middle and renamed "lots" to "buffer overflow", which is basically what we work with today.
PS: Oh, I forgot about negative numbers. We have those, too. They are quite easy to visualize: It's like a room where 10 people go in and 15 people come out. Now 5 people have to go in for it to be empty again.
[Updated on: Fri, 22 August 2008 18:59] Report message to a moderator
|
|
|
|
|
|
|
|
Re: calculate the max and sum value by weird way !!! [message #342628 is a reply to message #342626] |
Sat, 23 August 2008 06:36  |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
Hany Freedom wrote on Sat, 23 August 2008 13:09 | I know that there are better ways from what I said ......... but I was just talking about the new idea that may help us in another calculates 
|
Yes, the more difficult this approach is, the worse it performs (in comparition with SUM). So I do not see where could it help (except in making the code less transparent and slowing down the execution).
flyboy wrote on Sat, 23 August 2008 07:51 | By the way, how would you SUM values e.g. 3,4,5
| Maybe you know other methods, but I would do it in the same way the "new idea" calculates it. So I would rather re-classify it to the "old idea" (procedural, non-SQL).
|
|
|