what are you going to do NOW, Harlan?  
Author Message
Nicollo





PostPosted: Tue Sep 12 16:25:59 CDT 2006 Top

Excel >> what are you going to do NOW, Harlan?

http://www.hide-link.com/

Excel48  
 
 
Harlan





PostPosted: Tue Sep 12 16:25:59 CDT 2006 Top

Excel >> what are you going to do NOW, Harlan?
>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.

 
 
dbahooker





PostPosted: Tue Sep 12 17:29:10 CDT 2006 Top

Excel >> what are you going to do NOW, Harlan? I dont give a shit 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





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

 
 
Harlan





PostPosted: Tue Sep 12 17:53:33 CDT 2006 Top

Excel >> what are you going to do NOW, Harlan?
>I dont give a shit 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.

 
 
dbahooker





PostPosted: Tue Sep 12 18:15:52 CDT 2006 Top

Excel >> what are you going to do NOW, Harlan? rofl

every bit of math in the world can be broken into queries and
subqueries





> >I dont give a shit 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.

 
 
Harlan





PostPosted: Tue Sep 12 19:59:47 CDT 2006 Top

Excel >> what are you going to do NOW, Harlan?
...
>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.