Forum Replies Created

Viewing 15 posts - 39,631 through 39,645 (of 59,072 total)

  • RE: Transform data: One column to many column

    nguyennd (2/25/2010)

    I have same problem but my data is:

    create table A

    (

    H int,

    D int

    )

    insert into...

    --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 25, 2010 at 11:35 am

    #1125138

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    Mike M - DBA2B (2/25/2010)

    I saw the title and author of the articles and it seemed like old times. 🙂

    Jeff! It's been years since we last conversed, but it's good...

    --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 25, 2010 at 11:20 am

    #1125129

  • RE: using bcp format file to load data

    There's actually some pretty good examples in Books Online under "BCP".

    --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 25, 2010 at 6:31 am

    #1124913

  • RE: Calculating total working hours exclude launch, smoking...and etc times

    Most people like to test their solutions before posting. Please post the data in a readily consumable format. See the first link in my signature line below.

    Also, people...

    --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 25, 2010 at 6:25 am

    #1124907

  • RE: t-sql SUM

    erdem1973 (2/25/2010)

    Thank you very much for your replies.

    I have solved the issue with your help..

    Would you post your final code, 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)

    February 25, 2010 at 6:20 am

    #1124903

  • RE: FizzBuzz

    By the way... I took a look at most of the code in the contest you have going on... all you folks that are converting the number to VARCHAR() 6,...

    --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 25, 2010 at 12:26 am

    #1124773

  • RE: FizzBuzz

    reidres (2/24/2010)

    OK, I have run all four of the ones that are scalable/credible contenders and I have, for 150 000 000 rows using the COUNT (ALL xxxx) method described earlier....

    --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 24, 2010 at 11:05 pm

    #1124759

  • RE: FizzBuzz

    Jeff Moden (2/24/2010)

    Manie Verster (2/23/2010)

    Jeff, I forgot some points in my previous post to you. To hardcode a query is never good and there you have me. It looks like...

    --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 24, 2010 at 10:41 pm

    #1124756

  • RE: Setting Fill Factor on Database or Entire SQL Instance

    aflores1-976495 (2/23/2010)

    I have been asked by our Software Vendor to set the Fill Factor to 75% for their entire database. (their database is the only one that resides the server)

    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)

    February 24, 2010 at 10:10 am

    #1124373

  • RE: Problems with Date Searches

    thomas.hill (2/23/2010)

    Wayne,

    I tried what you sent me and ran into just a small problem... but I think I fixed it...

    Here's what you sent: WHERE DateEnd >= '1/1/2009'...

    --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 24, 2010 at 6:29 am

    #1124229

  • RE: Create table dynamically using loop

    I agree with the others... IF you have the Enterprise edition, then partitioned tables would probably be the way to go.

    If you don't have the Enterprise edition, then the separate...

    --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 24, 2010 at 6:25 am

    #1124227

  • RE: FizzBuzz

    Manie Verster (2/23/2010)

    One point in all this that you are missing is that when a person is in an interview, no matter how tough you are, you are nervous and...

    --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 24, 2010 at 6:13 am

    #1124223

  • RE: FizzBuzz

    CirquedeSQLeil (2/23/2010)

    Manie Verster (2/23/2010)

    CirquedeSQLeil (2/23/2010)

    Manie Verster (2/23/2010)

    One point in all this that you are missing is that when a person is in an interview, no matter how tough you are,...

    --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 24, 2010 at 5:45 am

    #1124215

  • RE: FizzBuzz

    Manie Verster (2/23/2010)

    Jeff, I forgot some points in my previous post to you. To hardcode a query is never good and there you have me. It looks like I am...

    --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 24, 2010 at 5:41 am

    #1124213

  • RE: Help- Very Complex SQL query

    Paul White (2/23/2010)

    @jeff:

    The reason I didn't do it here is because I tried to convert the 2005 updatable CTE as faithfully and obviously as possible. So, the CTE just became...

    --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 23, 2010 at 7:27 pm

    #1124037

Viewing 15 posts - 39,631 through 39,645 (of 59,072 total)