Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 4,080 total)

  • RE: Are the posted questions getting worse?

    First off I will apologize in advance, but I think all of you are correct.

    Second, for a change, I would like to post a (rare?) example of an OP who...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Subquery in Case When that can produce multiple results for IN query

    No problem, Nathan. Happy to be of help. I'm sorry about the display of the blank row. Obviously, I just sort of...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Subquery in Case When that can produce multiple results for IN query

    Why do a CASE? If you are determined to go this route, why not just use OR?

    Where InvestorCode is null OR investorCode = @investorCode

    ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Querying on field with multi-values

    The following schema would make your job easier in the long run. Especially if your next question is going to be how to identify which events are going...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: File purge maintenance plan

    This will get you started. You can run this code to get the list of files and their dates into a table. You can...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: trigger

    Are the inserts part of a transaction that might be rolled back after the INSERT is completed?

    Emails can't be rolled back.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    No, I haven't seen Spamalot...... Guess I'll need to wait until they make a movie out of it.

    SOM !!!! :-P:w00t::-P:w00t:

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    SOM. 😛 I am so sorry I missed that, jc. I had quite forgotten about that nefarious invention.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Performance issue with tally solution

    That was an eggseptionally good pun, Jeff.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    No such place.

    Yes, Gail, I know. I'm not that out of touch with reality.

    I'm just pleased you caught the reference.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    THREAD ALERT!! THREAD ALERT!!

    Rapidly closing in on 8000 posts.*

    Round up the usual suspects.

    *I started to say 8k, but Emperor Paulpatine and others would...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Durban? Hell, no. I'm in JHB.

    How close to District 9?

    What's next, the Castle Anthrax is an unrealistic portrayal of medieval monastic orders?

    Bad, wicked Zut.

    I want to face the peril!

    No, it's...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Performance issue with tally solution

    Tune in same time next week for another episode of "Cooking with SQL."

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Performance issue with tally solution

    What's the sound of one hand clapping?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: ONLINE index rebuild adds one extra byte to non-clustered indexes

    I wonder if this might be related to some internal process within the ONLINE index build that expands the 'permanent' extra byte to a smallint through necessity. A small mismatch...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 15 posts - 2,371 through 2,385 (of 4,080 total)