Viewing 15 posts - 56,131 through 56,145 (of 59,067 total)
Why can't you change it? Because it's 3rd party???? or ????
June 13, 2007 at 12:07 pm
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?
June 13, 2007 at 12:03 pm
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...
June 13, 2007 at 11:59 am
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?
June 13, 2007 at 11:51 am
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...
June 13, 2007 at 11:48 am
Now we're cookin'... nicely done.
June 13, 2007 at 11:26 am
No... no query... the recommendation was to use a "Calendar Table"... there are many to choose from if you search this site.
June 13, 2007 at 11:21 am
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...
June 13, 2007 at 10:18 am
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...
June 13, 2007 at 10:11 am
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,...
June 13, 2007 at 10:06 am
Besides, Wutang... you don't want us to have ALL the fun, do ya? ![]()
MrPoleCat and JLK... thank you guys for the awesome compliments. ...
June 13, 2007 at 9:34 am
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...
June 12, 2007 at 11:31 pm
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...
June 12, 2007 at 10:36 pm
Viewing 15 posts - 56,131 through 56,145 (of 59,067 total)