Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 4,080 total)

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/8/2010)


    Here's one for y'all.

    I couldn't resist... 😛

    __________________________________________________

    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: Purpose of few SSIS Packages

    I've used SSIS to:

    1. rethread particulate data out of a table and back into itself to avoid locks due to trigger overlap

    2. derive up to 137 parameters for...

    __________________________________________________

    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?

    Post is this commutative?

    __________________________________________________

    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?

    I refuse to dignify that with a comment that I have edited to make Lynn curious.

    __________________________________________________

    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: Return groups in random order

    I second ColdCoffee's motion. Sample schema with scripts to populate them with sample data and a picture of expected results are what we need to give definitive (even...

    __________________________________________________

    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: help in avoiding loop

    My eyes walked right past that. Time for new glasses. Thank you for pointing out my error, Tom. 🙂

    __________________________________________________

    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: Nice one, please read and give your comments.

    Got it. That is the first time I've seen this trick, and it's a clever variation. Thanks for sharing it. 🙂

    I just tested the both...

    __________________________________________________

    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: Creating Indices on Temp Tables from Stored Procedures

    Jeff, my example used daily reports, not monthly like I kept saying, but I didn't change anything about the runtimes. Here is what I posted and what I meant.

    If...

    __________________________________________________

    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?

    IBM S/32-38 used the 8 inch floppies (originally called diskettes, but I believe the French found this somewhat inappropriate.) They were a GREAT improvement over decks 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: Nice one, please read and give your comments.

    Could you post up some working code that uses CHARINDEX?

    I'm not sure I understand how that works or what it will do for you.

    __________________________________________________

    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: Creating Indices on Temp Tables from Stored Procedures

    Absolutely, it depends. ("It depends, it depends." sounds redundundant.)

    To me that means the same thing as "It's a judgment call." What I'm curious about is...

    __________________________________________________

    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: Creating Indices on Temp Tables from Stored Procedures

    That argument ignores the context, the concept of opportunity cost, the concept of diminishing returns, and the value of human time. All it does is use the ancient dialectic...

    __________________________________________________

    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: Creating Indices on Temp Tables from Stored Procedures

    It will also server as a better example of how to write code in the future so that when someone copies the code because "it's close to what is...

    __________________________________________________

    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: DBCC Timewarp

    All of which are dependent on your alternate reality ID (ARID) value.

    __________________________________________________

    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: Creating Indices on Temp Tables from Stored Procedures

    Including moderation.

    To heck with Russell's Paradox.

    __________________________________________________

    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 - 1,636 through 1,650 (of 4,080 total)