Forum Replies Created

Viewing 15 posts - 38,671 through 38,685 (of 59,098 total)

  • RE: convert string to ascii values

    LondonNick (4/30/2010)

    A very similar script is in BOL if you look up CHAR.

    Agreed... and it shouldn't be used either. 😉

    For those that haven't seen it, please see the following for...

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

    May 1, 2010 at 5:07 pm

    #1160936

  • RE: convert string to ascii values

    Jon McGhee (4/30/2010)

    Cool. I did not know that, but I see it now. Usually when I look for code examples I don't search BOL, I search this site....

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

    May 1, 2010 at 5:03 pm

    #1160935

  • RE: Median

    keywestfl9 (5/1/2010)

    yes it helped to finish my task. thank you all for the help

    They want to do for another report in access the same thing,i will try and post 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)

    May 1, 2010 at 4:48 pm

    #1160934

  • RE: MCJ - The Missing Link

    CirquedeSQLeil (4/29/2010)

    Lynn Pettis (4/29/2010)

    CirquedeSQLeil (4/29/2010)

    Steve Jones - Editor (4/29/2010)

    I went back and looked at the wording in Jeff's draft. The issue there is that many of us borrow code for...

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

    May 1, 2010 at 10:00 am

    #1160909

  • RE: MCJ - The Missing Link

    Steve Jones - Editor (4/29/2010)

    I went back and looked at the wording in Jeff's draft. The issue there is that many of us borrow code for others and use 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)

    May 1, 2010 at 9:06 am

    #1160904

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (4/30/2010)

    Lynn,

    I think it was OK. From a technical standpoint, it makes sense. The issue seems that some people don't understand log chaining, so things read funny...

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

    May 1, 2010 at 8:52 am

    #1160901

  • RE: Median

    @keywestfl9,

    So... are you all set now or do you have other questions about MEDIANs?

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

    May 1, 2010 at 8:48 am

    #1160900

  • RE: Cast Float to Char with Natural Rounding

    Paul White NZ (5/1/2010)

    Jeff Moden (4/30/2010)

    Using the great start that Paul provided, the following will also drop the decimal point if a whole number is realized...

    Great stuff! Thanks so...

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

    May 1, 2010 at 8:43 am

    #1160899

  • RE: Table and design advice

    Digs (5/1/2010)

    Thanks Jeff, Speed much improved !!

    :-):-D:-):-D

    Thanks for the feedback, Digs. 🙂

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

    May 1, 2010 at 8:39 am

    #1160898

  • RE: Tempdb GROWS

    2cams (4/30/2010)

    Hi Grant, Solarwinds is a server performance monitoring application which is 3rd party. We logged a call with them enquiring about the tempdb issues we haing.

    We will monitor 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)

    April 30, 2010 at 11:33 pm

    #1160867

  • RE: Trying to use variables in a view.

    itskumar2004 (4/26/2010)

    Hi,

    I want to use a variable in a view.so i created a stored procedure and in that i have created a view .but, when i used the variable ina...

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

    April 30, 2010 at 11:27 pm

    #1160865

  • RE: SP_EXECUTESQL

    ravikanth232 (4/30/2010)

    Thanq...

    that helped me...procedure is working not.

    You're welcome. I'm assuming that you really meant "procedure is working now".

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

    April 30, 2010 at 11:17 pm

    #1160864

  • RE: Table and design advice

    Heh... you also need speed to insert and doing it the way I suggested will help both speed to read and speed to insert.

    PK's are only clustered by default. ...

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

    April 30, 2010 at 11:14 pm

    #1160863

  • RE: Why rebuild statistics on large, older tables?

    Have the best of both worlds... from Books Online...

    In SQL Server 2005, sp_updatestats updates only those statistics that require updating based on the rowmodctr information in the sys.sysindexes compatibility view;...

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

    April 30, 2010 at 11:06 pm

    #1160861

  • RE: Need help with the query. Can not filter out data

    yogesh_pandey (4/30/2010)

    Got it working thank you.

    Two way steet here... please post your solution. Thanks.

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

    April 30, 2010 at 10:53 pm

    #1160858

Viewing 15 posts - 38,671 through 38,685 (of 59,098 total)