Forum Replies Created

Viewing 15 posts - 26,341 through 26,355 (of 59,099 total)

July 29, 2013 at 8:53 am

#1636677

  • RE: Database import from text/csv file and many to many relationship

    I absolutely agree with Erland. There are dozens of ways to skin this cat and this is an excellent opportunity to compare the different methods and learn their strengths...

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

    July 29, 2013 at 7:49 am

    #1636643

  • RE: A New Look

    I just took a look at the home page for the first time this morning. Why in the hell do people think that change is always for the better?...

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

    July 29, 2013 at 7:44 am

    #1636641

  • RE: Conditional print for testing scripts.

    ben.brugman (7/29/2013)

    Jeff Moden (7/26/2013)

    Using PRINT for troubleshooting can be a real PITA and the output sometimes doesn't show up until the end of the run instead of as the procedure...

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

    July 29, 2013 at 7:31 am

    #1636633

  • RE: Explanation of LIKE '%[0-9]%'?

    Eugene Elutin (7/29/2013)

    Solomon Rutzky (7/27/2013)

  • 23847234872893475983479583749583749573945739 is all digits, is a valid number, but is NOT convertible to any SQL Server number types as it is larger than 38 digits

    • ...

    You can...

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

    July 29, 2013 at 7:23 am

    #1636629

  • RE: general

    paul.knibbs (6/26/2013)

    Jeff Moden (6/25/2013)

    No. NULLs cannot be compared to so they would also be excluded from any check for <> 0. Try it an see.

    I would tend 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)

    July 28, 2013 at 9:19 pm

    #1636522

  • RE: A New Look

    Hooray! The "old look" is back! 🙂

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

    July 28, 2013 at 9:06 pm

    #1636521

  • RE: SQL Query

    vshiva2379 (7/28/2013)

    I am very Sorry about that but i was bit worried with the query i was not getting, Thanks allot to every one, I got my answer and 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)

    July 28, 2013 at 9:03 pm

    #1636520

  • RE: What's in your CLR?

    Wesley.Groleau (7/28/2013)

    Jeff Moden (7/27/2013)

    Wesley.Groleau (7/27/2013)

    (snip) Sure, a stored procedure CAN do it, but a script component or other CLR is easier. (snip)

    I guess my question would be, why do you...

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

    July 28, 2013 at 9:00 pm

    #1636518

  • RE: Database import from text/csv file and many to many relationship

    zqckfair (7/28/2013)

    Thank you for this very well explained answer and that useful link.

    Sorry for the ambiguity, but unfortunately I'm also having problem with the import, in fact, it is my...

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

    July 28, 2013 at 6:53 pm

    #1636507

  • RE: Database import from text/csv file and many to many relationship

    I'm assuming that you've already imported the data into a staging or other table. If you're also having problems with the import, we need to know what is...

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

    July 28, 2013 at 7:14 am

    #1636462

  • RE: SQL Query

    vshiva2379 (7/28/2013)

    Execuse me

    Since you did not understand i how given that data and more over i do not want to disclose my original data i have given that, if...

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

    July 28, 2013 at 6:31 am

    #1636458

    • Viewing 15 posts - 26,341 through 26,355 (of 59,099 total)