Forum Replies Created

Viewing 15 posts - 39,706 through 39,720 (of 59,072 total)

  • RE: Help- Very Complex SQL query

    Sash Mav (2/19/2010)

    Ohh buddy - that worked like a charm. I am such a fool not to think from basics.

    Arun certainly has the correct idea but, being the author of...

    --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)

    February 21, 2010 at 7:00 pm

    #1122638

  • RE: ALTER a HUGE TABLE

    Vinay,

    I've not read all of the posts on this thread so let me ask... can the system be down while you do this or not? If so, for how long?

    --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)

    February 21, 2010 at 6:19 pm

    #1122629

  • RE: Eliminating Cursors

    Very cool set of links, Barry. Great blog site on your part, as well! Other than the awesome content (haven't explored it all, yet, of course) is that...

    --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)

    February 21, 2010 at 10:06 am

    #1122514

  • RE: Temporal Query Problem

    My bad... I didn't explain well enough. You need to find the OPEN for each CLOSED in order to pick up on the "reopens".

    So far as 45 and 51...

    --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)

    February 20, 2010 at 5:58 pm

    #1122402

  • RE: Temporal Query Problem

    dataczar (2/18/2010)

    It does have a row that shows open sometime during that month, but we are only looking at the snapshot at the end of the month.

    I guess I wouldn't...

    --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)

    February 19, 2010 at 8:43 pm

    #1122237

  • RE: Temporal Query Problem

    dc,

    Account 2 does a pending, closed, pending, closed, pending, open.

    How should that be considered, please?

    Also, can I assume the "pending" means the same as "open" for this problem?

    --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)

    February 19, 2010 at 6:52 pm

    #1122223

  • RE: Import Excel Spreadsheet to Database Tables

    peterhe (2/18/2010)

    This is too much to our customers.

    Heh... been there and done that so very much understood. It's amazing that we let some folks have a computer.

    Thanks 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)

    February 19, 2010 at 6:17 am

    #1121770

  • RE: Temporal Query Problem

    dataczar (2/16/2010)

    Jeff,

    I think you are thinking of Peso's Subscription speed challenge query, which I have looked at but this has a few more complexities because you need to calculate new,...

    --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)

    February 19, 2010 at 6:12 am

    #1121767

  • RE: Eliminating Cursors

    RBarryYoung (2/18/2010)

    1. Dynamic SQL is not the problem, Injection IS.

    2. SQL Injection uses Dynamic SQL, but the two are far from synonymous.

    3. Dynamic SQL is just a...

    --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)

    February 19, 2010 at 5:40 am

    #1121754

  • RE: Eliminating Cursors

    ksh (2/18/2010)

    Dynamic SQL allows for the creation of command(s) from a complex set of parameters/variables/conditions. When used properly it enables the centralization, extensibility and re-use of sp code.

    The SQL...

    --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)

    February 19, 2010 at 5:33 am

    #1121747

  • RE: Quick Suggestion on Table Variable

    Ather M (2/18/2010)

    Thanks a lot for all your suggestions...

    I will definetly compare the performance....but before starting I need some expert comments thts why I posted it 🙂

    I am really looking...

    --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)

    February 18, 2010 at 10:15 pm

    #1121563

  • RE: help with query to compress the adjacent records into one

    No problem... if you post the data in a readily consumable format like what is done in the first link in my signature below, I'm sure that some of the...

    --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)

    February 18, 2010 at 10:08 pm

    #1121561

  • RE: Tally table ASCII validator - Anyone ever did this?

    J-F Bergeron (2/18/2010)

    Thanks Peter, it makes sense that limiting the number of rows in the tally table makes it faster. I'm just surprised the "Where len(value) <= tally.N" did not...

    --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)

    February 18, 2010 at 10:05 pm

    #1121560

  • RE: SQL Server local variables

    What's the rest of the query? I want to see why you're using a loop.

    --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)

    February 18, 2010 at 8:29 pm

    #1121544

  • RE: Automating Backups using SQLMD

    tstapenhorst (2/18/2010)

    I would like to request another set of eyes to see an issue that I'm missing. I using a Windows Command file from our "Management" server (non-SQL) to...

    --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)

    February 18, 2010 at 8:05 pm

    #1121540

Viewing 15 posts - 39,706 through 39,720 (of 59,072 total)