 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006what are you going to do NOW, Harlan?
http://sqlserverdatamining.com/DMCommunity/TipsNTricks/70.aspx dbahooker@hotmail.com wrote... >http://sqlserverdatamining.com/DMCommunity/TipsNTricks/70.aspx And what do you suppose all those asterisks before many of the Excel function names mean? Same as Excel function support under MDX? (What'll be next, XMD or XDM?) If so, that means they're NOT SUPPORTED. So, if I needed LinEst or MMult, I'd continue using Excel. You'd do something different in no small part because you have no clue what these functions do. I dont give a sh.t what they do; there's never been anything in the database world that stumps me the basic math that you do in excel deserves to be in a database > dbahooker@hotmail.com wrote... > >http://sqlserverdatamining.com/DMCommunity/TipsNTricks/70.aspx [quoted text clipped - 5 lines] > different in no small part because you have no clue what these > functions do. dbahooker@hotmail.com wrote... >I dont give a sh.t what they do; there's never been anything in the >database world that stumps me That's the problem with militant ignorance like yours - it's so stupid it believes it's a virtue. Maybe nothing in the database world stumps you because no one tries to do anything particularly complex numerically in the database world. The fact that Excel's more advanced numeric functions aren't in the database world tends to support the case that there are some things databases can't do. >the basic math that you do in excel deserves to be in a database Yes, the *basic* math I do could be done in a database. It's the intermediate to advanced calculations that require more numerically capable software. rofl every bit of math in the world can be broken into queries and subqueries > dbahooker@hotmail.com wrote... > >I dont give a sh.t what they do; there's never been anything in the [quoted text clipped - 14 lines] > intermediate to advanced calculations that require more numerically > capable software. dbahooker@hotmail.com wrote... ... >every bit of math in the world can be broken into queries and >subqueries ... Everything can be boiled down to 4 operator arithmetic, but (1) it's grossly inefficient to do so, and (2) you'd have no clue how to represent even exponentiation to fractional powers or logarithms using just +, -, *, /. Since queries and subqueries are the only way to render mathematical expressions in SQL, you're correct in theory, but as usual your database suggestions would be so inefficient that no one other than you would try to follow them.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.