Forum Replies Created

Viewing 15 posts - 46 through 60 (of 111 total)

  • RE: Encrypting SQL Code

    AndyD (4/10/2009)


    The quantum guys say there is no way to predict the flip of a coin. Einstein would argue there is. IFF you knew all of the forces...

  • RE: Encrypting SQL Code

    AndyD (4/10/2009)


    Like being pregnant or dead, either you are, or you aren't.

    have you heard of Schrödinger's cat??? 😛

    I have, but it was 20 years ago. My progression through...

  • RE: Encrypting SQL Code

    Most of the work I do here supports "internal" clients. The parts that support external clients is only accessible via web based reports (CE). The work for the...

  • RE: The T-SQL Paradigm

    Jeff Moden (4/7/2009)


    Other people love the darned things and that's fine for them... just don't want anyone forcing such rules on me.

    I'm stepping out on a limb here....

    Didn't you...

  • RE: The T-SQL Paradigm

    YSLGuru (4/7/2009)


    I'm going from memeory and it has been a while back but we ran into a problem where the order of the grouping did matter and it very well...

  • RE: The T-SQL Paradigm

    Michael Valentine Jones (4/6/2009)


    YSLGuru (4/6/2009)


    Jason Miller (4/6/2009)


    GSquared (4/3/2009)


    For example, why doesn't this work:

    select Col1, count(*)

    from dbo.MyTable;

    And the follow-up where,

    -SNIP-

    I don't see how the example you gave would give you different...

  • RE: The T-SQL Paradigm

    YSLGuru (4/6/2009)


    For example in an apartment complex you may have several types of units. If you wanted a count of these and you grouped by Unit Type then Unit...

  • RE: The T-SQL Paradigm

    GSquared (4/3/2009)


    For example, why doesn't this work:

    select Col1, count(*)

    from dbo.MyTable;

    And the follow-up where,

    select Col1, Col2, count(*)

    from dbo.MyTable

    GROUP BY Col1, Col2;

    select Col1, Col2, count(*)

    from dbo.MyTable

    GROUP BY Col2, Col1;

    Are not equal (in...

  • RE: The T-SQL Paradigm

    fnoell (4/3/2009)


    I guess I should be happy that IF...THEN was not changed to POSSIBLY...THEREFORE.

    OTHERWISE .....

    We could market the new linguistically challenged version SCL...

    Super Confusing Langauge...

  • RE: The T-SQL Paradigm

    GSquared (4/3/2009)


    Quite obviously, it is meant to be contained in the Group By, so why not implicitly include it? Sure, that may be a violation of the standard, but...

  • RE: The T-SQL Paradigm

    Having started my db work in EXEC, REXX, RAMIS (sp?), and the like, then moving on to procedural programming languages in college, Modula-2 for the most part, after college...

  • RE: Are We Wasting Too Much Time Social Networking?

    Too much of a substitute for actually going out and doing something. Live your reality, don't pretend.

    Quite some time ago, I was the philanthropic chair of my fraternity. ...

  • RE: Annoyances

    We have an interesting chap here...

    For some ungodly reason he ALWAYS composes his emails as follows. In the little box that says subject, he'll type:

    "Topic: Some...

  • RE: The Need for Tape

    blandry (3/26/2009)


    But if you knew that you would spend say 20 or 30 years in jail for such behavior, wouldn't that at least help deter this kind of thing? ...

  • RE: SQL Server Knockoffs?

    AndyD (3/20/2009)


    Wow, that is scary! And programmers get paid to write this pile of %#*@

    You could always suggest that they save money by migrating to mySQL, or PostGreSQL, or even...

Viewing 15 posts - 46 through 60 (of 111 total)