Why can't you change it?  Because it's 3rd party???? or ????

You're saying the format of a given text file changes a lot???  Do the text files have header information on the first line of the file?

Nope... can't be done in EM... open the view code in Query Analyzer first... save the old code... copy the code to EM... experiment with changes... copy/type the changes into Query...

That's cool... do you know if table variables still have the same fault of not being able to use statisics and not be alterable once formed?

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