I agree with you both... one of the more import facts is that a lot of folks who write SQL code embedded in whatever app they're writing, have no real...

Now we're cookin'... nicely done.

No... no query... the recommendation was to use a "Calendar Table"... there are many to choose from if you search this site.

Just curious... why do you need a single column?

Just a bit of a follow up on the suggestion that dates and times be formatted by the GUI...

If you have an international presence, many GUI's can be "programmed" to...

Was actually wondering when you'd show up on this, Mr. Burrows... you normally have some pretty good tricks up your sleeve   I'm going...

Very cool... Thanks for taking the time to explain in such great detail.  Just for grins, I also checked Excel... the standard rounding functions don't appear to do Banker's Rounding...

Actually,...

Thanks, Wutang.

Besides, Wutang... you don't want us to have ALL the fun, do ya?

MrPoleCat and JLK... thank you guys for the awesome compliments. ...

Ok... thanks David...

And I agree... Heh... after the last thread about this, I started asking all my CPA "friends" about it... out of 18 CPA's, only 2 of them even knew...

There are two basic types of medians and, as David McFarland points out, there are several special mods like not counting zeros, dropping the ends, and a whole bunch of...

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...