Thread: why>?

aaron.kempf@gmail.com wrote...
>RE:
....
>here's my goddamn solution ok buddy?
>
>create table N
>(N INT NOT NULL)
>go
>insert into n(n)
>values (1)
>go
>insert into n(n)
>values (2)
>go
>insert into n(n)
>values (3)

The forgoing so much easier than creating a list in Excel.

>then if you want your precious little permutations
>
>Select N1.N N1, N2.N N2, N3.N N3
>From N N1, N N2, N N3
>Where N1.N <> N2.N AND N1.N <> N3.N AND N2.N <> N3.N
>order by 1, 2, 3

Finally!

Very good.

Except that the Where clause grows factorially. Becomes a bit of a pain
to handle 8 distinct tokens using

SELECT T1.N AS N1, T2.N AS N2, T3.N AS N3, T4.N AS N4, T5.N AS N5, T6.N
AS N6, T7.N AS N7, T8.N AS N8
FROM T AS T1, T AS T2, T AS T3, T AS T4, T AS T5, T AS T6, T AS T7, T
AS T8
WHERE ((T1.N<>T2.N) And (T1.N<>T3.N) And (T1.N<>T4.N) And (T1.N<>T5.N)
And (T1.N<>T6.N) And (T1.N<>T7.N) And (T1.N<>T8.N)
And (T2.N<>T3.N) And (T2.N<>T4.N) And (T2.N<>T5.N) And (T2.N<>T6.N)
And (T2.N<>T7.N) And (T2.N<>T8.N)
And (T3.N<>T4.N) And (T3.N<>T5.N) And (T3.N<>T6.N) And (T3.N<>T7.N)
And (T3.N<>T8.N)
And (T4.N<>T5.N) And (T4.N<>T6.N) And (T4.N<>T7.N) And (T4.N<>T8.N)
And (T5.N<>T6.N) And (T5.N<>T7.N) And (T5.N<>T8.N)
And (T6.N<>T7.N) And (T6.N<>T8.N)
And (T7.N<>T8.N))
ORDER BY T1.N, T2.N, T3.N, T4.N, T5.N, T6.N, T7.N, T8.N;

Then there's runtime. Your query's comparison operations make this an
O((N+1)!) procedure. Table-driven permutation generation, such as found
in

http://groups.google.com/group/micro...1e73ffd974b4d2

will be much faster for 8 or more distinct tokens.

>sorry.. I didn't understand that you assumed that cartesianing is
>always out of control complete and utter cartesianing.
>
>you see; you can combine a join and a whereclause with some
>cartesianing in order to control the result set.

OK, so you're not using the strict, Codd definition. Fine. You don't
use much other terminology in the strict sense, so silly me for
expecting otherwise.

Harlan. I know you are having fun but your blood pressure is going up. Let's
quit feeding the troll. He has been here before for food.

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Harlan Grove" <hrlngrv@aol.com> wrote in message
news:1148503225.549444.160120@j73g2000cwa.googlegroups.com...
> aaron.kempf@gmail.com wrote...
>>re:
>>No, data exists independent of storage medium/mechanism. But not
>>surprising that you're limited worldview can't cope with that.
>>
>>no Harlan-- you're wrong.
>>
>>Data-- Nice-- Usable-- Reliable Data-- shouldn't be stuck in data
>>islands and duplicate copies.
>>how many copies of the same data do you keep; Harlan?
> ...
>
> First, acording to you there was no data before the UNIVAC post WW2. It
> may be the case that you'd be at a complete loss for how to do anything
> (even find your butt with both hands) if you didn't have a database to
> help you do so.
>
> Few if any. You may not know how to use spreadsheets competently, but
> there are at least a few million people around the world who can.
>
>>What happens when you need to change a calendar to account for a new
>>national holiday?
>
> What idiot, aside from you, keeps a calendar in Excel? If you mean with
> regard to the NETWORKDAYS or WORKDAY functions, you obviously don't
> know how to use workbook templates and store shared read-only files on
> file servers. Put commonly used data, such as company holiday lists, in
> named ranges in a workbook, save that workbook read-only in a server
> share, create workbook templates with defined names referring to named
> ranges in the shared workbook as external references. Change all such
> templates by changing the server file once.
>
> To repeat, that you don't know how to use Excel competently implies
> nothing about whether there are or aren't MANY Excel users who are MUCH
> MORE competent.
>
>>you have to sit there and loop through hundreds of spreadsheets and
>>copy and paste stuff until you turn blue.
> ...
>
> Or use a canned macro written years ago to make batch changes iterating
> through a table of affected workbook files and a table of range
> addresses and replacement formulas. If you're not competent to
> administer Excel models . . .
>
>>Data should be centralized and LEVERAGED so that you're automagically
>>10% exponentially faster the next time you run the same report-- you've
>>already got the infrastructure there.
> ...
>
> 10% exponentially faster?! More random verbiage.
>
> And if only all work were generating reports.
>
>>and DONT USE EXCEL FOR REPORTING AGAINST DATABASES. IT ISN'T
>>FUNCTIONAL ENOUGH TO BE USED FOR A SINGLE SMALL ONE-TIME REPORT.
>
> Thanks. I'll keep that in mind if I ever have to create reports again.
>

dbahoo...@hotmail.com wrote...
>what you're missing is that SQL Server is better than this.
>it doesn't actually calculate each possible row and then filter them
>out.

It doesn't generate each tuple, but it does have to perform
comparisons.

Try generating some tables with 12 to 20 distinct values, time how long
it takes the queries to run, then plot those run times.

>i can out-develop you harlan.
....

In databases and web pages, probably. Financial simulation models, I
doubt it.

>screw you-- just because you took a couple of programming classes
>doesn't make you an expert.
....

As opposed to you CLAIMING you're an expert? Any proof?

A simple Google Groups search shows that your postings in database ngs
are usually as vacuous as your postings in this ng.

dbahoo...@hotmail.com wrote...
>who cares about non-wintel systems?
>
>sql server owns the olap market www.olapreport.com and their database
>is quite strong these days.
>
>IIS has made great strides; IIS 7 is going to make it even more
>critical to use a real OS for web servers
....

Netcraft still shows more than 2.5 times as many web sites running
Apache as running IIS. Facts (as opposed to 'data') are such awkward
things.

First of all, HI TO EVERYONE!!! Quit every argument will you?? I had both knowledge of access and excel. They are good and bad. But whats the point of arguing when you don't even need to worry for your client and boss (who might be using either one)?? You will still survive with the kowledge you have now right? The quarrel you all having now is like "Is Jesus a human?" (no offence) . They are prove that both are right and wrong. Just satisfy yourselve and let this matter rest. No point straining yourselves trying to find a bad point of other program when you don't appreciate judgement other made for the program you using. To end the case why don't everyone just take the "opinion" and close the case ? Anyway, by arguing don't provide us food and money.

First of all, HI TO EVERYONE!!! Quit every argument will you?? I had both knowledge of access and excel. They are good and bad. But whats the point of arguing when you don't even need to worry for your client and boss (who might be using either one)?? You will still survive with the kowledge you have now right? The quarrel you all having now is like "Is Jesus a human?" (no offence) . They are prove that both are right and wrong. Just satisfy yourselve and let this matter rest. No point straining yourselves trying to find a bad point of other program when you don't appreciate judgement other made for the program you using. To end the case why don't everyone just take the "opinion" and close the case ? Anyway, by arguing don't provide us food and money.

Originally Posted by noob2

First of all, HI TO EVERYONE!!! Quit every argument will you?? I had both knowledge of access and excel. They are good and bad. But whats the point of arguing when you don't even need to worry for your client and boss (who might be using either one)?? You will still survive with the kowledge you have now right? The quarrel you all having now is like "Is Jesus a human?" (no offence) . They are prove that both are right and wrong. Just satisfy yourselve and let this matter rest. No point straining yourselves trying to find a bad point of other program when you don't appreciate judgement other made for the program you using. To end the case why don't everyone just take the "opinion" and close the case ? Anyway, by arguing don't provide us food and money.

sorry for this double reply... Com lag... HAHA

there is no such thing as 'financial simulation models'

all there is is data and i use the right tool; you use a crutch.

and because of this you have the capabilities of a 3rd grader.

dbahoo...@hotmail.com wrote:
[snip weapons grade balonium]
> excel is a girly-man program.

Heh heh. That's why I can consistantly bill $85/hr doing
development in it. Heh heh.
Socks

oh boy.. $85 huh??

big spender, big spender

just because you con people into using it doesnt mean it's worth.

you and the other 100m spreadsheet dorks in the world-- altogether the
worth of every spreadsheet created by every spreadsheet dork.. is equal
to ZERO.

there has never been a single spreadsheet developed that is worth a
penny.

Is that so?!? I wonder how much does each table in access cost... Everything has a price my friend. There is nothing call worthless and priceless... Its human that make it that way accroding to their needs. So there is no good or bad, only need or dun need.

listen idiot do you really believe that anyone uses netscape for
anything anymore??

Yep, idiot, some of us do, becuase we hate most things MS.

Except Excel, of course.

-)

aaron.kempf@gmail.com wrote:

> listen idiot do you really believe that anyone uses netscape for
> anything anymore??
>

wow you guys are really stuck in the 90s.

it makes me sick to think that you guys get paid for copying and
pasting; your company should hire a bunch of monkeys-- literally

hammering away with a big button that says copy and a big button that
says paste.

they could build the same **** you do but they woudln't be such a PITA


and seriously

you dumbshits have never written a webpage in your lives; so why in the
**** do you guys give a **** about apache vs iis?

furthermore; does this show what is being used for INTRANET sites?


INTRANET sites-- where a user in an office can talk to a web
applicaiton without having to sign-in every 30 seconds-- is almost
exclusively the domain-- pun intended-- of IIS.

IIS allows you to authenticate and double-hop authentication i mean

apache doesnt even come close to this same functionality

but the point of the matter is that if you dipshits knew how to spell
HTML you would be writing webpages and not jerking off to microsoft
excel
so who gives a flying **** what you guys say?

i respect apache

apache and php-- even mysql is a great product.

but in real - world -- corporate implementations?

they suck ballz compared to iis.

i just think that it's hilarious that you guys sit there and talk ****
about MS.
when you smoke MS pole every day by using this diseased program called
Excel.

the worst program; the worst time-waster-- ever written.

grow some balls and start doing databases kids; you'll be amazed that
**** gets easier for you and you're not stuck with a billion documents
filled with spaghetti code references.

excel is just impossible to manage.

one of these days i'll get my application working again-- called 'grade
your beancounter'

and i'll give all you fucktards a big fat F for productivity.

-Aaron