David Jackson,

Does the function you posted work as described in the code or is there a problem with it... just trying to figure out where THIS thread is gonna go...

David,

Just making sure of a nuance to Banker's Rounding... it implies rounding to the nearest penny (hundreths) no matter how many decimal places may be involved... is that correct?  (I...

Ummmm.... yeah.... I'm going to need you to move your desk to the basement.

No... you didn't miss it... have always wondered why they went from minutes right straight to milliseconds my own self... for that matter, why didn't they just include a programmable...

Heh... thanks for the nice compliment, but I'm just another Homer like everyone else... sometimes I can make things work ... sometimes not...

Neat trick, Peter... I've got a couple of places where that's gonna come in handy!

Adam,

Are you all set have Remi's suggestion or are you still having problems?

THAT's one of the things I like about you, ALZDBA!!  Need more folks that can come back and say "Dang, made a mistake".  Rare breed indeed

Oh heck yeah!  Sorry Cory... I forgot about that!   I remembered the fax but forgot the message

ISFA = "In So Far As" if that's what you meant by "WTF does that mean?"... or did you have a different question, Cory?

Dunno where you came up with "PC...

Any chance that table 2 could have new rows in it that aren't in table 1, yet?

Heh... using a tool like Query Builder is great for certain tasks... but, I...

Everytime I think of any type of rounding ISFA money is concerned, I keep thinking of that wonderfully silly movie called "Office Space"... if you haven't seen it, go rent...

Adam...

What do you want to happen if the amount of data exceeds the VARCHAR(250) column you've outlined?

Simply stated... YES... that's exactly the way to do it.  As Serqiy pointed out, there are some performance issues that will resolve AND there are other benefits down the line, as well.

There are...

Sure... it's definitely a trick... we needed some way to aggragate all of the "findings" to a single row for each ID/name.  We also needed the some aggragate to wrap the...