Forum Replies Created

Viewing 15 posts - 51,466 through 51,480 (of 59,098 total)

  • RE: Could I eliminate this cursor?

    Cory Ellingson (3/28/2008)

    I could VERY well be wrong on this, as I am just starting to work with CTE's, but something like this may work...

    WITH TEST_CTE_Insert (...

    --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 28, 2008 at 8:48 pm

    #795556

  • RE: How to convert char to real to numeric

    Robert (3/28/2008)

    Numeric is decimal, so it must be used whenever accuracy matters.

    I was with you all the way up until you said that...

    If you do cascaded conversions like this, what...

    --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 28, 2008 at 7:20 pm

    #795543

  • RE: Four Rules for NULLs

    kaspencer (3/28/2008)

    Sorry, but because I couldn't read your post while writing my reply, I forgot to add my third point:

    By the way, if you scroll down when constructing a reply,...

    --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 28, 2008 at 6:13 pm

    #795540

  • RE: Four Rules for NULLs

    Ok... it's all semantics... I call zero "nothing" and an empty string "nothing" and I say "Null is NOT nothing". You say Null is nothing. I disagree, but...

    --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 28, 2008 at 6:09 pm

    #795537

  • RE: What would you do?Update situation....

    You bet... and thanks for the great feedback!

    --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 28, 2008 at 6:01 pm

    #795536

  • RE: How to convert char to real to numeric

    Kevin Durham (3/28/2008)

    Thanks rbarryyoung,

    You confirmed what I feared was true from what I had read elsewhere. If REAL only holds 7 digits, and the other 15 are lost, I have...

    --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 28, 2008 at 5:45 pm

    #795531

  • RE: Bulk-Logged Recovery Model

    David Naples (3/27/2008)

    Have fun with THIS.

    Pleasant surprise... there's even some documentation in the code... thanks David.

    --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 28, 2008 at 5:26 pm

    #795526

  • RE: Bulk-Logged Recovery Model

    Ignacio A. Salom Rangel (3/27/2008)

    I think that you should Really consider using third party tools.

    Don't leave us hanging... spit it out.. WHICH 3rd party tools would you recommend?

    --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 28, 2008 at 5:20 pm

    #795523

  • RE: Four Rules for NULLs

    Mike C (3/28/2008)

    I get a clustered index scan when I run your code. The optimizer expands it out to RowNum <> 1 AND RowNum <> 2 AND RowNum <> 3.

    Hmmm......

    --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 28, 2008 at 5:06 pm

    #795517

  • RE: are there "arrays" in sql 2005 ?

    blahknow (3/26/2008)

    I've been told i must send a string and create a function to change the string into a table and i guess thats what i'll do unless i hear...

    --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 28, 2008 at 5:00 pm

    #795514

  • RE: are there "arrays" in sql 2005 ?

    dfalso (3/28/2008)

    Jeff Moden (3/28/2008)

    Any code to go along with this "FWIW"? 😉

    What, you want answers too? 🙂

    Heh... no... just wanted to know if I was gonna have to write some......

    --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 28, 2008 at 4:54 pm

    #795513

  • RE: Four Rules for NULLs

    Gregg Walker (3/28/2008)

    Thanks Michael. I will stick with NVL for now as CASE is more verbose and is not easy to do a find and replace on. 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 28, 2008 at 1:40 pm

    #795457

  • RE: Four Rules for NULLs

    Jim Russell (3/28/2008)

    Having just gone through 11 (enlightening) pages of this thread, I hope I just have not missed the answer to my question:

    Since nulls will group together in a...

    --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 28, 2008 at 1:37 pm

    #795455

  • RE: Four Rules for NULLs

    kaspencer (3/28/2008)

    However, I do not consider the NULL to be "missing data". The NULL must simply be considered as either "no value", or "value not [yet] assigned".

    Heh... what the heck...

    --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 28, 2008 at 1:35 pm

    #795452

  • RE: Four Rules for NULLs

    Mike C (2/25/2006)

    NULL is not a value...

    Spot on! Hence the T-Shirt that says "NULL Is NOT Nothing!" 😀

    --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 28, 2008 at 1:31 pm

    #795444

Viewing 15 posts - 51,466 through 51,480 (of 59,098 total)