Forum Replies Created

Viewing 15 posts - 33,271 through 33,285 (of 59,099 total)

  • RE: loops

    mister.magoo (7/17/2011)

    The Dixie Flatline (7/11/2011)

    If anyone would post up some examples where a cursor solution outperforms a set-based solution, I will look at them respectfully.

    Bob

    This brought back memories of 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)

    July 17, 2011 at 6:57 pm

    #1354022

  • RE: loops

    GPO (7/17/2011)

    Hi Bob (Dixie etc)

    Re:

    If anyone would post up some examples where a cursor solution outperforms a set-based solution, I will look at them respectfully.

    Here's an interesting discussion I...

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

    July 17, 2011 at 11:37 am

    #1353970

  • RE: order by some records only

    CELKO (7/16/2011)

    Jeff, I now call the list of integers table the Series(seq) table because SEQUENCE is a reserved word for a new construct.

    Hmmm... Joe, I have to ask... Since 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)

    July 17, 2011 at 8:50 am

    #1353954

  • RE: Create View- T-SQL Syntax error

    SQLkiwi (7/16/2011)

    I normally write such stubs the other way around, to avoid all that tedious messing about with quotes in the view definition:

    IFOBJECT_ID(N'dbo.MyView', N'V')

    IS NULL

    EXECUTE ('CREATE VIEW dbo.MyView AS SELECT...

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

    July 17, 2011 at 8:16 am

    #1353951

  • RE: Create View- T-SQL Syntax error

    opc.three...

    IIRC, in the "CREATE or REPLACE" in Oracle (and, I believe, in the ANSI standard), the "REPLACE" is equivalent to an "ALTER".

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

    July 17, 2011 at 8:05 am

    #1353950

  • RE: A Little Interviewing Advice

    TravisDBA (7/16/2011)

    Jeff Moden (7/16/2011)

    TravisDBA (7/15/2011)

    I'll take a good ADMIN over a good query person every time. 😀

    I'm greedy... I want and get both in the same person. 🙂 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)

    July 16, 2011 at 11:08 pm

    #1353918

  • RE: Are the posted questions getting worse?

    WayneS (7/15/2011)

    Lynn Pettis (7/15/2011)

    Chad Crawford (7/15/2011)

    Craig Farrell (7/14/2011)

    Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real...

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

    July 16, 2011 at 10:58 pm

    #1353917

  • RE: A Little Interviewing Advice

    TravisDBA (7/15/2011)

    I'll take a good ADMIN over a good query person every time. 😀

    I'm greedy... I want and get both in the same person. 🙂 It sometimes takes 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)

    July 16, 2011 at 11:18 am

    #1353866

  • RE: loops

    kritika (7/14/2011)

    all,,

    i got my solution... thanks newaz...

    Very cool. Would you mind posting it so that others may learn from your experience, please?

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

    July 16, 2011 at 11:08 am

    #1353865

  • RE: order by some records only

    Correct me if I'm wrong, Joe, but the SEQUENCE construct is only new to SQL Server... it's been around in products, like Oracle, for a very long time.

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

    July 16, 2011 at 11:05 am

    #1353864

  • RE: How to get count for week range?

    Except for in a function or view where you can't actually use a SET statement, I have no problem with the idea of setting DATEFIRST to whatever I need 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)

    July 15, 2011 at 8:30 pm

    #1353800

  • RE: Too much for too little

    Nilesh Deshpande (6/28/2011)

    Hi,

    I work on a sql server 2000 database at office and then at my residence.

    Till now, when the database size was small enough, I used to do...

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

    July 15, 2011 at 8:23 pm

    #1353799

  • RE: SSIS Trimming Leading Zero (Stumped)

    Thanks for posting what you found. I don't know much about SSIS and every bit helps.

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

    July 15, 2011 at 8:17 pm

    #1353797

  • RE: SQLCMD data truncated

    Lonely Rogue (7/15/2011)

    Thanks for the reply...

    and any help on explaning about those switches.

    Also, I should have set some background why I chose this approach... ok, here it is..

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

    July 15, 2011 at 8:13 pm

    #1353796

  • RE: How to use Cursor to get desired result.

    It looks like "Opening" is simply the difference between the previous "Opening" and the previous "Balance". Is that correct?

    I also suggest that you read the article at the first...

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

    July 15, 2011 at 7:32 pm

    #1353795

Viewing 15 posts - 33,271 through 33,285 (of 59,099 total)