Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

Re: PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic

Discussion in 'Information Technology' started by Lonnie M., Nov 10, 2005.

  1. Lonnie M.

    Lonnie M.
    Expand Collapse
    Guest

    >...and now im making 8x as much money as i was back then.

    As an employer, I don't believe that I would pay such a narrow-minded
    agitator $8 dollars an hour. It would be refreshing to see you go one
    post attempting to come up with something other than a four letter word
    to emphasize your point. I doubt that you will change the manner in
    which you communicate or the value you place on the right tools for the
    right job--whether that be spreadsheets or 'novel' languages. That
    is why we will always see you as a belligerent one-trick-pony.

    Harlin, thank you for your positive contributions to the community

    Regards--Lonnie M.
     
  2. Loading...

    Similar Threads Forum Date
    General Help! Looking for a good clairvoyant/card reader......any suggestions? Please Blogs Jan 25, 2016
    Can I be sure God wants me to be a Sikh? [PLEASE READ] Questions and Answers Jul 2, 2012
    Sikh Coalition Revised Sikh Air Traveler's Guide (Please read) Sikh Organisations Jan 14, 2011
    Please read …. Hard Talk Mar 12, 2006
    Sikhs For Change Rules - Please Read! Sikh Sikhi Sikhism Sep 6, 2005

  3. JakeyC

    JakeyC
    Expand Collapse
    Guest

    aaron -

    Unlike Mr. Toews, I note that you are neither valuable, nor
    professional.

    If your use of spreadsheets involves re-creating them several times a
    week or 'copying and pasting' 100 times over, perhaps you should get
    back to basics.

    Press 'F1' on your keyboard, and type the word 'macro' into the speech
    bubble that the cute animated assistant offers.
    You may well learn something.
     
  4. Lonnie M.

    Lonnie M.
    Expand Collapse
    Guest

    >WHAT HAPPENS WHEN YOU HIT 64K ROWS, KID?
    > little script kiddie


    Aaron, The fact that you would even ask the question regarding 65,536
    rows, just goes to show your ignorance. Like, I said the right tool for
    the right job... By the way when I hit 64K rows I would still have
    1,536 to go!
    I will use access, mysql, sas, oracle, notepad, or even crayons and
    construction paper! Whatever serves my needs the best, but when you
    make statements like "[I would never use] Excel in the real world"
    -- it kind of makes you out to be the "One Trick Pony". You
    obviously are not a professional, because you clearly do not understand
    the needs of the "Real World", or customers in the "Real
    World". You can pretend that "Real World" only needs what you are
    endorsing, but you are wrong. Chances are you are the "Kiddie"
    here, judging by the immaturity of your responses. And the verdict is
    still out on whether or not you are the "Script Kiddie".

    Go get them tiger, the whole world is against you, but you know that
    you are right! So, keep striking out in angst -- you really are a sad,
    sad boy.
     
  5. Harlan Grove

    Harlan Grove
    Expand Collapse
    Guest

    Harlan Grove wrote...
    ....
    >But if joins aren't necessary, I suppose 11 separate queries aren't
    >necessary. Should be syntactically possible to use
    >
    >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, T9.N AS N9, T10.N AS N10, T11.N AS N11, T12.N
    >AS T12
    >FROM T T1, T T2, T T3, T T4, T T5, T T6, T T7, T T8, T T9, T T10, T
    >T11, T T12
    >WHERE ((N1<>N2) AND (N1<>N3) AND (N1<>N4) AND (N1<>N5) AND (N1<>N6)
    >AND (N1<>N7) AND (N1<>N8) AND (N1<>N9) AND (N1<>N10) AND (N1<>N11)
    >ND (N1<>N12) AND (N2<>N3) AND (N2<>N4) AND (N2<>N5) AND (N2<>N6)

    ....

    Poor syntax in the WHERE clause. Me bad.

    I just tried this out in Access. Given T with one field named N
    containing long integers from 1 to 12, Access generated the
    permutations of 6 items using the query

    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
    FROM T AS T1, T AS T2, T AS T3, T AS T4, T AS T5, T AS T6
    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 (T2.N<>T3.N) AND (T2.N<>T4.N) AND (T2.N<>T5.N)
    AND (T2.N<>T6.N) AND (T3.N<>T4.N) AND (T3.N<>T5.N) AND (T3.N<>T6.N)
    AND (T4.N<>T5.N) AND (T4.N<>T6.N) AND (T5.N<>T6.N))
    ORDER BY T1.N, T2.N, T3.N, T4.N, T5.N, T6.N;

    *BUT* Access couldn't handle a similar query to generate the
    permutations of 8 items using the query

    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 T7, T 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;

    It aborted with the message 'Not enough space on temporary disk.'

    FWIW, Excel wouldn't have an easy time with that either since it'd
    require 305 worksheets to hold all 20 million-odd permutations.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page