Viewing 15 posts - 301 through 315 (of 727 total)
If I'm understanding you correctly, even this should work...
SELECT
MaxCol1 = Max(Column1)
,MaxCol2 = Max(Column2)
,Column3
,MaxCol4 = Max(Column4)
FROM
Table
GROUP BY
Column3
June 13, 2007 at 12:45 pm
Can an Appl_ID (and name for that matter) belong to more than one facility? Can an MRP_ID belong to more than one Appl_ID?
Edit: Ignore the first question, as you've answered...
June 13, 2007 at 12:11 pm
David Jackson,
I ran your latest function with the code below, and it passes the initial smell test, returning the values I would expect it to return for the test parameters...
June 13, 2007 at 11:40 am
Even Excel does it, but using a different function. Excel, due to how it is often used, has a ton of different rounding methods. One of them, "Even", is Banker's...
June 13, 2007 at 11:29 am
The value I supplied was indeed 2/3. Did you actually read the code?
Yes, 2/3*3 in the environment I ran the tests in does indeed return 2.
Keep digging.
June 13, 2007 at 8:46 am
"Sorry, David,
I see you're not only bad in math, you're bad in reading."
The irony, it burns.
All your books tell about approximations, roundings, but not representations before rounding.
Rounding is exactly how...
June 13, 2007 at 8:42 am
It did exactly what you asked. Perhaps you should go back and read both what you asked, and what I posted.
June 13, 2007 at 6:24 am
Feel free to point that person out. .666 is not a good representation for 2/3. .666..., on the other hand, is a wonderful representation for 2/3, as is .6, .6~, and...
June 13, 2007 at 6:16 am
Jeff, it's actually a bit more commonly used than the anecdotal evidence would lead you to suggest, it's just poorly named. To be fair, it also has a ton of...
June 13, 2007 at 5:46 am
Why would you keep waiting for code that was supplied in the second post on page 30, right after you asked for it?
June 12, 2007 at 9:05 pm
It can denote rounding to the nearest penny, but it's not really a banking specific function (it's actually not widely used by banks as far as I know, but far...
June 12, 2007 at 9:03 pm
I had versions of all three at a previous contract, but their's were overly complicated for your needs, as they had all sorts of parameters allowing you to eliminate zeros,...
June 12, 2007 at 6:05 pm
I actually own a Red Swingline.
Piece of trivia. Red Swinglines did not exist when Office Space came out. Due to the subsequent volume of requests for them, they released one.
June 12, 2007 at 6:00 pm
David, while I agree that it was his intention, he didn't actually crap in this thread (I realize that the day isn't over yet), as his post was useful to demonstrate...
June 12, 2007 at 5:14 pm
How many pieces of flair do they make you wear at work?
June 12, 2007 at 5:10 pm
Viewing 15 posts - 301 through 315 (of 727 total)