Forum Replies Created

Viewing 15 posts - 45,331 through 45,345 (of 59,101 total)

  • RE: SQL Server 2005 upgrade changes column order of tables.

    rich.ramos (2/2/2009)

    The PeopleTools upgrade would not affect the field order of custom records. And the column order does not affect the way the PeopleSoft application interacts with the table....

    --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 2, 2009 at 6:59 pm

    #936861

  • RE: What Duties Would a Junior DBA Have?

    John Bates (2/2/2009)

    hi DBAs,

    I'm a Oracle and SQL Server 2005 DBA for my employer. I have been asked to list some of the skills that a *Junior* DBA position would...

    --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 2, 2009 at 6:54 pm

    #936856

  • RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

    GSquared (2/2/2009)

    Go for it. Might take more than a quarter, so don't be disappointed if you aren't up to Jeff Moden's or Gail's skill level by that time.

    :blush: ...

    --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 2, 2009 at 6:38 pm

    #936851

  • RE: SQL or Oracle

    Jeff Moden (2/2/2009)

    noeld (2/2/2009)

    Bruce W Cassidy (2/2/2009)

    [font="Verdana"]Relational Integrity is over-rated.

    OMG, did I really just say that? And I was just reading an article by Joe Celko too! Aaaargh!...

    --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 2, 2009 at 5:51 pm

    #936834

  • RE: SQL or Oracle

    noeld (2/2/2009)

    Bruce W Cassidy (2/2/2009)

    [font="Verdana"]Relational Integrity is over-rated.

    OMG, did I really just say that? And I was just reading an article by Joe Celko too! Aaaargh! 😛

    [/font]

    If...

    --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 2, 2009 at 5:49 pm

    #936832

  • RE: list of month names and week ranges between dates

    ghughes (2/2/2009)

    ok, I give up. I defer to everyone greater judgement in the matter. Make perfect sense. I have created table......thank you for the help.

    in...

    --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 2, 2009 at 5:35 pm

    #936824

  • RE: Keeping user database in memory

    noeld (2/2/2009)

    I am going to say this one last time, I promise. FIX THE APP!

    Heh... and I'll keep on saying it... FIX THE APP! 😛

    --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 2, 2009 at 5:32 pm

    #936820

  • RE: SQL or Oracle

    Bruce W Cassidy (2/2/2009)And I was just reading an article by Joe Celko too! Aaaargh! 😛

    [/font]

    A solution of Boric Acid, Silver Sulphate, and a little saline water will...

    --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 2, 2009 at 5:28 pm

    #936817

  • RE: Top 1 or Max??

    GSquared (2/2/2009)

    If there are multiple rows with the same date-time in the MyDateColumn, the first query will only give you one of them, but the second query will give you...

    --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 2, 2009 at 5:22 pm

    #936814

  • RE: Using trim with Join

    benlatham (2/2/2009)

    Right, I am was interested because I have encountered this issue myself. Sometimes you want spaces in the parameter label so trimming before loading in to the parameter...

    --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 2, 2009 at 5:16 pm

    #936812

  • RE: Sql Query Help

    Grant Fritchey (2/2/2009)

    Jeff Moden (2/1/2009)

    Grant Fritchey (1/23/2009)

    There are three ways you can do this easily. Use TOP, MAX or ROW_NUMBER.

    I'm thinking this one isn't about how to create the next...

    --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 2, 2009 at 5:13 pm

    #936809

  • RE: Sql Query Help

    Thanks, Mahesh. 🙂

    --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 2, 2009 at 4:26 am

    #936332

  • RE: insert records into another table.

    sandy (2/2/2009)

    When i run this code is sql 2000 i get an error of

    Server: Msg 195, Level 15, State 10, Line 27

    'ROW_NUMBER' is not a recognized function name. but 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)

    February 2, 2009 at 4:17 am

    #936325

  • RE: insert records into another table.

    It's kind of a moot point now because the op said they're using SQL Server 2000, but here's the 2005 rendition I came up with. The output is 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 2, 2009 at 4:13 am

    #936323

  • RE: insert records into another table.

    Vladan (2/2/2009)

    Jeff Moden (1/31/2009)

    Vladan, check your code... I don't believe it's coming up with the correct result set.

    I checked it and either I'm blind (quite possible, I'm still only half...

    --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 2, 2009 at 4:08 am

    #936318

Viewing 15 posts - 45,331 through 45,345 (of 59,101 total)