Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 2,443 total)

  • RE: Joining Multiple Tables - What is the correct order on JOINS?

    CELKO (8/11/2010)


    JOINs of all kinds are done in left to right order and follow the usual rules for parens. Use your parens to be sure the order is right. ...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Finding Unique Non-Repeating Random Numbers

    Great article Brandie, like how you offered multiple solutions and showed how you worked through them.

    Jeff likes to use ABS(CHECKSUM(NEWID())) to generate random numbers, I haven't done any testing...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (8/12/2010)


    jcrawf02 (8/12/2010)


    I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of a primary...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (8/11/2010)


    That's a whole nutha topic there.

    Pronunciation: \'wu?s-t?(r)-?shir-, -sh?r- also -?shi(-?)r-Function: noun

    Etymology: Worcestershire, England, where it was originally made

    Date: 1843

    : a pungent sauce whose ingredients include soy, vinegar, and garlic

    I...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/11/2010)


    How about Worcester?

    If you read German & English the correct pronunciation is, of course:

    Vorchester

    If you're from Massachusetts though, you'd say:

    Woostah

    Figure that one out.

    Hmm, there's a Wooster Ohio, you...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Ray K (8/11/2010)


    Kit G (8/11/2010)


    Ray K (8/11/2010)


    Ah -- if I remember my Rochester geography correctly, you were in Chili or Henrietta (or somewhere thereabouts), is that right? I can...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (8/11/2010)


    I was just remembering one of my favorite cartoons from "The Far Side", Chris. 🙂

    The comics world lost a great humorist when...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: SSRS 2000 Can you base one dataset on another dataset

    Luke, check this out: http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/62731/%5B/url%5D, and I believe this would be usable in 2000 also, you'd just have to pass it as a string and convert to XMLdata, iirc.

    Haven't found...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: SSRS 2000 Can you base one dataset on another dataset

    Gotcha, thanks, sorry to muddy the waters in a thread about 2000, wasn't thinking...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: A Quick Look at the MPP World

    Nice article, David!

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: SSRS 2000 Can you base one dataset on another dataset

    Hmm Luke, you're making me rethink something... so if I have a dataset I could potentially take the results of that dataset and pass as a Table-Valued Parameter into a...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (8/10/2010)


    I've turned the kids onto chorizo here, and that's supplanted bacon most of the time.

    Now I'm hungry. Favorite dish at a local Mexican joint, chicken, chorizo,...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    once again, the power of The Thread is evident...I just walked into the break room to fill up my water, and there are Nerds just sitting there, waiting to be...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/10/2010)


    ignore please - slow responding browser caused me to click on the wrong button.

    so.....treat your post as we normally do? :hehe:

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 15 posts - 1,186 through 1,200 (of 2,443 total)