Forum Replies Created

Viewing 15 posts - 2,401 through 2,415 (of 2,443 total)

  • RE: never heard of built-in function row_number?

    Something I think you'll find here is that even if you don't agree with an author, or you find an article to be somewhat less than helpful to your situation,...

    ---------------------------------------------------------
    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: Presentation tips

    All good tips, the one thing to remember at all times when speaking to any level of management is to represent in black and white how what you are presenting...

    ---------------------------------------------------------
    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: Do You Want to Be Right?

    GSquared (6/16/2008)


    Say an airplane's navigation system. That must not give an incorrect result.

    It depends on "incorrect". If, for example, precision exceedes accuracy, that's wasted effort.

    If an airplane's (or ship's)...

    ---------------------------------------------------------
    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: Concatenate Results Into A Single Field

    Matt Miller (6/16/2008)


    Jeff - I will post my own script later. I kind of got busy yesterday and didn't get a chance to come back and finish the thought...

    ---------------------------------------------------------
    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: Concatenate Results Into A Single Field

    rbarryyoung (6/15/2008)


    Jeff Moden (6/15/2008)


    What's wrong with a good ol' concatenation function that works in 2k and 2k5?

    Are we thinking of the same thing? I thought the concatenation function was...

    ---------------------------------------------------------
    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: Do You Want to Be Right?

    I think you're all saying basically the same things, you need your software to be 'directionally correct', as the finance folks at my organization like to say. If it doesn't...

    ---------------------------------------------------------
    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: Eliminating Cursors

    Is a 'test-off' like a 'dance-off'? should I go get some cardboard?

    ---------------------------------------------------------
    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: Eliminating Cursors

    Michael MacGregor (6/13/2008)


    The trick is to return a resultset of the new IDs for the UI to use, and that's easy as pi.

    Not being able to resist . . .

    precisely...

    ---------------------------------------------------------
    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: Eliminating Cursors

    When I began reading this article, I wondered why it had been chosen to be re-posted, as I've read several other articles by Jeff, Matt, et al that demonstrate the...

    ---------------------------------------------------------
    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: The Vacation Dilemma

    I can only think of one response to this article -

    http://www.fourhourworkweek.com

    Not affiliated to Tim Ferriss at all, just jealous. (and plotting . . .);)

    ---------------------------------------------------------
    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: The Software Comparison - Part 4

    Which damn government?

    ---------------------------------------------------------
    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: Mixing DDL and DML - DECLARE and SET - Which is which?

    Thanks guys, appreciate the clarification. That's exactly what I was looking for.

    ---------------------------------------------------------
    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: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Let's see if you have access to some of the local system objects... what do you get when you run the following with no reference to the Master database?

    [font="Courier New"]SELECT...

    ---------------------------------------------------------
    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: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    David Jackson (5/22/2008)


    Using your test data, what would you expect this to return?

    DECLARE @rebuildMe varchar(2000), @iteration int

    SET @rebuildMe = ''

    SELECT @rebuildMe = @rebuildMe + cast(n as varchar(10)) + ' '...

    ---------------------------------------------------------
    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: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Hugo Kornelis (5/23/2008)

    Addendum 1: A relational purist would even consider the (usual) result of this technique to be a bug. After all, relational databases are supposed to execute queries such...

    ---------------------------------------------------------
    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 - 2,401 through 2,415 (of 2,443 total)