Forum Replies Created

Viewing 15 posts - 36,091 through 36,105 (of 59,099 total)

  • RE: Linking to the Previous Row

    David McKinney (11/13/2010)

    I meant that specifically the different approaches to the "previous / next row" problem haven't been compared side by side.

    Exactly. Here's code to build 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)

    November 13, 2010 at 6:36 pm

    #1250395

  • RE: Include end date on a history record?

    MattieNH (3/7/2008)

    Heh... ok... let me turn that around on you... isn't a column that serves two purposes like wearing two watches? 😉

    Jeff,

    I don't think so, but since I didn't think...

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

    November 13, 2010 at 6:06 pm

    #1250393

  • RE: TSQL Best Functionalities needed

    Lynn Pettis (11/13/2010)

    First, Jeff, I thought that giving the OP some guidance in what direction he should look was appropriate. Sorry if that disappointed you, seemed the right thing...

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

    November 13, 2010 at 5:17 pm

    #1250392

  • RE: TSQL Best Functionalities needed

    Lynn Pettis (11/12/2010)

    First, we aren't going to give the answers to these interview questions, you need to research them yourself and determine what other methods you could apply to solve...

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

    November 13, 2010 at 1:29 am

    #1250340

  • RE: 2 questions... first x > '' vs x <> ''

    CELKO (11/9/2010)

    Do not use the old dialect != from C and Sybase.

    I've been trying to get people out of the habit of using != but they're just not buying my...

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

    November 12, 2010 at 11:16 pm

    #1250333

  • RE: Does SQL Server have functionallity like Oracle's %Type Attribute

    OracleWho (11/12/2010)

    In Oracle, when you declare a variable or parameter in a procedure, you can set the datatype to be the same as a specific column (or even a row)...

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

    November 12, 2010 at 11:07 pm

    #1250331

  • RE: Alternative To Cursors?

    sqldba_icon (11/12/2010)

    Just wanted to throw out a question to developers on what method do they use to loop around different objects.I typically use cursors, was wondering if there is...

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

    November 12, 2010 at 11:02 pm

    #1250330

  • RE: Creating versions of records in tables

    nidhis (11/12/2010)

    Hi,

    I have to design a module in an existing system wherein I need to create versioning in the database for a workflow.

    I have thought of two options:

    1. When 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)

    November 12, 2010 at 10:59 pm

    #1250329

  • RE: TSQL Best Functionalities needed

    srinadh.ramineni (11/12/2010)

    Hi for the below questions i need good and efficient answers. Below are the inrterview questions asked in one interview. I am having the real time exp. But 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)

    November 12, 2010 at 10:34 pm

    #1250326

  • RE: TSQL Best Functionalities needed

    Please folks... these aren't difficult questions that the OP has been asked. And this is for a job in a competative world. The OP should know the answers...

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

    November 12, 2010 at 10:28 pm

    #1250325

  • RE: Week Part

    WayneS (11/12/2010)

    Michael Valentine Jones (11/12/2010)

    Note that any Monday date, not just 1753-01-01, can be used as long as it is earlier than OriginalDate. I chose 1753-01-01 because it is...

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

    November 12, 2010 at 8:51 pm

    #1250317

  • RE: Week Part

    Michael Valentine Jones (11/12/2010)

    Just a little nitpicking on this; Jeff's code does not work on dates before 1899-12-25.

    Heh... actually, nitpicking appreciated here. I'm one of the first to always...

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

    November 12, 2010 at 8:49 pm

    #1250316

  • RE: Are the posted questions getting worse?

    Paul White NZ (11/11/2010)

    Did you also bust the myth that table variables are always estimated as containing one row?

    Statement level recompile?

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

    November 12, 2010 at 8:18 am

    #1250044

  • RE: Week Part

    Hmmmm... you know... we run across this type of thing often enough... perhaps an "SQL Spackle" article is in order.

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

    November 12, 2010 at 8:06 am

    #1250033

  • RE: Week Part

    WayneS (11/11/2010)

    Well done Jeff. I turn the podium back over to the master.:-D

    Shucks :blush:... you folks are doing just fine and it's a pleasure to be in your good company....

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

    November 12, 2010 at 8:05 am

    #1250032

Viewing 15 posts - 36,091 through 36,105 (of 59,099 total)