Forum Replies Created

Viewing 15 posts - 59,011 through 59,025 (of 59,095 total)

  • RE: Cursor or String

    Rohit,

    The setbased logic you used in your example will almost always beat Cursors and WHILE loops.  Do you need any reason other than speed?  Ok, how about resource intensity, duration...

    --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 30, 2004 at 9:37 pm

    #508345

  • RE: i have a problem

    Sukio,

    There is an example query in "Books on Line".  To find it, lookup "expanding hierarchies" in the BOL index.  Be advised that it is not "bug free" and will require...

    --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 30, 2004 at 9:13 pm

    #508344

  • RE: WITH (NOLOCK)

    1)  Is the default on 'SELECT * FROM x' to lock each row?
    I don't believe so but could be wrong.
    2)  Should all SELECTS have WITH (NOLOCK)?
    Only if it's OK 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)

    May 29, 2004 at 9:59 pm

    #508333

  • RE: Parse Full name into first and last name.

    This should do it with some assumptions... the assumptions are that you will have no title (Mr., Mrs., etc) and no suffic (Jr. Sr. II, III, IV, etc).

    /******...

    --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 23, 2004 at 8:59 pm

    #507405

  • RE: Parse Full name into first and last name.

    David,

    If Edward is correct and all you really want is to split the last name from the rest and we assume that the last name will appear after the last...

    --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 21, 2004 at 6:27 am

    #507259

  • RE: How solve it??

    You have to convert @Count to VARCHAR or CHAR

    --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 21, 2004 at 4:58 am

    #507252

  • RE: CREATE PROCEDURE with a date condition on inseret

    Hi Midan,

    Guess there might be a little problem with the language barrier thing... let me see if I can clear it up...

    I believe your problem is that you want 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)

    May 20, 2004 at 6:56 am

    #507110

  • RE: I HAVE A SERIOUS PROBLEM

    Sukhoi,

    I don't know if the little bit of "language barrier" between us is a problem or if I'm just misreading this... just want to make sure you aren't stepping onto...

    --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 20, 2004 at 5:38 am

    #507096

  • RE: ANOTHER SERIOUS PROBLEM

    Sukhoi,

    Again, as in the post I answered for you previously, you need to do some conversions in the concatenization.  You have to CONVERT the date to VARCHAR or CHAR.  See...

    --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 20, 2004 at 5:29 am

    #507095

  • RE: concating strings

    Sukhoi,

    It's funny how the error message is sometimes the opposite of what it should be...

    Your problem is that the contents of one or more of your variables are numeric 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)

    May 20, 2004 at 5:24 am

    #507094

  • RE: UPDATE Query Question

    You never mentioned how long it was taking for the update...

    My experience for these two table type of single column update joins says you'll get about 4 million rows...

    --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 19, 2004 at 5:32 pm

    #507045

  • RE: right fill string characters

    paolice,

    Understood... I use "trial and error" a lot.  But you still haven't given me a clue as to how to use DataLength to determine the defined length of a column. ...

    --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 19, 2004 at 5:18 pm

    #507044

  • RE: right fill string characters

    Thanks Antares... didn't know that. 

    Hey paolice... how do you get DataLength to return the "defined length of your table's columns"?  Couldn't find a thing about that in BOL.

    --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 18, 2004 at 5:42 pm

    #506879

  • RE: How a procedure call procedure variable

    Errrr.... not sure just exactly what you're looking for so I offer this simple example on how to use a rowset from a stored procedure....

    USE PUBS

    GO

    SELECT a.*

    FROM OPENROWSET('MSDASQL',

                   ...

    --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 17, 2004 at 8:19 pm

    #506724

  • RE: right fill string characters

    Unless it was a text or ntext field, why would you use "DATALENGTH" over just "LEN" like some of the other replies used?   Just...

    --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 16, 2004 at 7:17 pm

    #506593

Viewing 15 posts - 59,011 through 59,025 (of 59,095 total)