Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Positive or Negative

    Eric M Russell (10/27/2015)


    However, if a single column approach is more appropriate, then I still prefer not to use 1 or 0 but rather a character using a less ambiguous...

  • RE: Positive or Negative

    leroux 56837 (10/23/2015)


    I suggest it depends on intent. If the intent is that the user must explicitly acknowledge that it is active then I would go for the positive...

  • RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

    The Wizard Of Oz (6/6/2014)


    ben.norris (6/6/2014)


    The Wizard Of Oz (6/6/2014)


    There's no dependance on ordering, so no cheating going on. It's a natural part of MIN() and MAX() functions.

    It would be...

  • RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

    The Wizard Of Oz (6/6/2014)


    There's no dependance on ordering, so no cheating going on. It's a natural part of MIN() and MAX() functions.

    It would be strange if someone caught SwePeso...

  • RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

    SELECTCustomerID

    FROM#Purchase

    WHEREProductCode IN ('A', 'B', 'C')

    GROUP BYCustomerID

    HAVINGMIN(ProductCode) = 'A'

    AND MAX(ProductCode) = 'B'

    --AND COUNT(*) = 2;

    This relies on A, B and C being ordered rather than some arbitary values that happen to...

  • RE: LEAD - 1

    craig 81366 (10/30/2012)


    ben.norris (10/30/2012)


    Hugo Kornelis (10/30/2012)


    ben.norris (10/30/2012)


    It doesn't state that the field is nullable

    First: It does. The CREATE TABLE script does not include a NOT NULL constraint, so the columns...

  • RE: LEAD - 1

    Hugo Kornelis (10/30/2012)


    ben.norris (10/30/2012)


    It doesn't state that the field is nullable

    First: It does. The CREATE TABLE script does not include a NOT NULL constraint, so the columns are all nullable.

    Second:...

  • RE: LEAD - 1

    An interesting question spoilt by the 3 points of ambiguity.

    Salesgoal mistake

    The Sales value for easy becomes 100, it is xray that is missing.

    It doesn't state that the field is nullable

Viewing 8 posts - 1 through 8 (of 8 total)