Forum Replies Created

Viewing 15 posts - 57,391 through 57,405 (of 59,067 total)

  • RE: how to select different from different tables

    Where is the Test info stored?  In the QuizLog?

    Sidebar... does you table actually have columns with spaces in the names ?

    I think it...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 16, 2006 at 6:56 am

    #665973

  • RE: best possibilities

    It sounds like the classic "make change" problem that used to be taught in many programming classes... I'm on my way to work right now but I think a function...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 16, 2006 at 6:49 am

    #665969

  • RE: Sql 2000 DTS timeout?

    Perfect case of too many cooks spoiling the broth Thanks for the feed back on what you found, Ville... definitely something to keep...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 16, 2006 at 6:42 am

    #665967

  • RE: Grouping total sales by payment type

    No.  Serqiy is correct... the table design is wrong... if you take multiple payments for a given invoice, you should have multiple rows.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 16, 2006 at 6:31 am

    #665965

  • RE: Grouping total sales by payment type

    Stephen,

    If you want separate totals for each payment type, then this would do...

     SELECT SUM(Cash)    AS TotalCash,

            SUM(Cheque)  AS TotalCheque,

            SUM(CC)      AS TotalCC,

            SUM(Account) AS TotalAccount

            SUM(Total)   AS GrandTotal

           ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 15, 2006 at 9:13 am

    #665909

  • RE: quantize ?

    quoteActually, none of them is absolutely right.

    If you have one that is, would you mind sharing it...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 15, 2006 at 9:03 am

    #665907

  • RE: quantize ?

    Thanks for the feedback, Mark...  this one was a lot of fun!

    Serqiy... I'd still like to know the "magic" behind your 5 second report, if you get a chance.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 14, 2006 at 4:30 pm

    #665894

  • RE: Grouping total sales by payment type

    Should the totals be by day for the range or are you just looking for a grand total for the range?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 14, 2006 at 8:31 am

    #665889

  • RE: quantize ?

    Thanks for the benchmark, Serqiy... the computed columns help a lot especially when you make them both deterministic so they can be indexed... got it down to 7 seconds on 4...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 14, 2006 at 1:34 am

    #665885

  • RE: quantize ?

    Mark,

    I don't know if I can get it to be a fast as Serqiy says he can, but I did get it down to 8 seconds...

    First, add this index...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 14, 2006 at 12:27 am

    #665884

  • RE: quantize ?

    Serqiy, my old friend... I'm all ears... there's code in the post to gen a million rows... can you show us how to get a similar report as the cross...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 13, 2006 at 10:56 pm

    #665883

  • RE: quantize ?

    Thanks Mark,

    I finally have enough information to help... with great zeal, I may add...

    First, as Serqiy suggested, you don't need all those "generated" columns.  He suggested keeping one of them...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 13, 2006 at 10:20 pm

    #665878

  • RE: is the sql server being smart or stupid?

    Of course there's some education in it, Ken... but, it's still forbidden because it hurts performance and a derived table should be used instead.  And, it will also catch these...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 13, 2006 at 5:54 pm

    #665872

  • RE: is the sql server being smart or stupid?

    Crud... I didn't read the second query... sorry... not enough coffee...

    To play on what David suggested... it's one of the reasons why I'm glad that the standards I wrote for...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 13, 2006 at 7:04 am

    #665714

  • RE: Generic Audit Trigger

    It's because the Inserted table is only available in the current session... the dynamic SQL is actually a separate session with a different scope.  That's the whole reason why we...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 13, 2006 at 6:57 am

    #665710

    • Viewing 15 posts - 57,391 through 57,405 (of 59,067 total)