Forum Replies Created

Viewing 15 posts - 39,181 through 39,195 (of 59,072 total)

  • RE: PIVOT FOR 2 or more Columns

    Bhavin_Bhatt25 (3/27/2010)

    Hi all.

    I have developed CTE which gives result using PIVOT; Its working perfect. as follows.

    Item Year ...

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

    March 27, 2010 at 1:43 pm

    #1140976

  • RE: Parse field with Numeric ranges and comma deliminated values

    Heh... absolutely remarkable. On a bit of a meloncholy note, it's amazing how things have changed in the last 7 or so years on this fine forum. "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)

    March 27, 2010 at 1:40 pm

    #1140975

  • RE: Money vs. Decimal Data type

    You're supposed to round the final answer.

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

    March 27, 2010 at 1:20 pm

    #1140970

  • RE: Debugging T-SQL

    IIRC, you need the Enterprise version of SQL Server to use DEBUG and you need some seriously elevated privs even then. The detailed information you seek is too 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)

    March 27, 2010 at 1:15 pm

    #1140968

  • RE: Is there a better way to write this query?

    I agree... something like an SSN could be couched in a column called GlobalReferenceNumber, etc. There's too much of a chance of missing something. Make the creators 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)

    March 27, 2010 at 1:11 pm

    #1140965

  • RE: How to use identity?

    I agree that the solution is fine... but why the need? What is the business requirement for this? I ask for the same reason for the question 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)

    March 27, 2010 at 1:07 pm

    #1140963

  • RE: Finding rows count in a table without Select...

    Chris Howarth-536003 (3/27/2010)

    DBCC UPDATEUSAGE - doesn't that only have to be run on SQL 2000 or upon upgrade from 2000 -> 2005?

    I thought the issue had been corrected in 2005...

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

    March 27, 2010 at 12:58 pm

    #1140961

  • RE: The Missing Certification

    Lynn Pettis (3/27/2010)

    Jeff Moden (3/26/2010)

    WayneS (3/26/2010)

    Lynn Pettis (3/26/2010)

    CirquedeSQLeil (3/26/2010)

    Lynn Pettis (3/26/2010)

    At this point, I'm ending this conversation. Let this thread get back on topic, which is The Missing Certification.

    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)

    March 27, 2010 at 12:50 pm

    #1140959

  • RE: The Missing Certification

    dma-669038 (3/27/2010)

    Certifications and other titles help the outside world understand what your experience is about not substitutes for experience.

    Heh... I have to agree that most folks use certifications and titles...

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

    March 27, 2010 at 12:16 pm

    #1140955

  • RE: The Missing Certification

    CirquedeSQLeil (3/26/2010)

    Even if somebody was a SQL stud with no experience, requiring them to be in the field for a couple of years prior to certifying them still brings greater...

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

    March 27, 2010 at 12:06 pm

    #1140954

  • RE: Finding rows count in a table without Select...

    If you need more accurate results, try using DBCC UPDATEUSAGE first. If you haven't done it in awhile, it could take some good bit of time and will take...

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

    March 26, 2010 at 9:16 pm

    #1140873

  • RE: Hunting and Gathering

    I, for one, still think the internet is a well paved onramp to a dirt road and it always will be because anyone can post about anything at anytime with...

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

    March 26, 2010 at 9:09 pm

    #1140871

  • RE: Table Splitting

    DBTeam (3/26/2010)

    Mainting large table is becoming difficult for us.

    Planning to split this table

    Please suggest us the best way of how can be done this..

    No front end access for this.

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

    March 26, 2010 at 8:39 pm

    #1140868

  • RE: The Missing Certification

    Nadrek (3/26/2010)

    WayneS (3/26/2010)

    One year isn't enough; three years is probably too much. Two sounds like a good middle to me.

    Now, how would one go about getting documented experience? I 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)

    March 26, 2010 at 8:06 pm

    #1140863

  • RE: The Missing Certification

    WayneS (3/26/2010)

    Lynn Pettis (3/26/2010)

    CirquedeSQLeil (3/26/2010)

    Lynn Pettis (3/26/2010)

    At this point, I'm ending this conversation. Let this thread get back on topic, which is The Missing Certification.

    I am more than willing...

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

    March 26, 2010 at 8:00 pm

    #1140862

Viewing 15 posts - 39,181 through 39,195 (of 59,072 total)