Forum Replies Created

Viewing 15 posts - 25,096 through 25,110 (of 59,102 total)

  • RE: SYNTAX Help please...

    ScottPletcher (12/18/2013)

    I'm truly curious now:

    Can anyone tell me:

    Where "IS NULL" can't be used in place of ISNULL()?

    Without the help of a CASE statement, lot's of places. Here's 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)

    December 18, 2013 at 9:10 pm

    #1674698

  • RE: SYNTAX Help please...

    Evil Kraig F (12/18/2013)

    ScottPletcher (12/18/2013)

    Yikes! Table values should be trimmed by a trigger once during insert/update if necessary rather than in every query afterward. If you really need...

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

    December 18, 2013 at 8:47 pm

    #1674697

  • RE: SYNTAX Help please...

    ScottPletcher (12/18/2013)

    At any rate, the ANSI-standard COALESCE() could always be used in place of ISNULL().

    Why? Do you believe in the myth of "portability"?

    COALESCE also has a hidden problem that ISNULL...

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

    December 18, 2013 at 8:39 pm

    #1674696

  • RE: SYNTAX Help please...

    ScottPletcher (12/18/2013)

    Evil Kraig F (12/18/2013)

    Scott,

    I'm not sure how that's more or less obscure, but it's certainly easier for me to read. I work with a lot of 'iffy' data...

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

    December 18, 2013 at 8:24 pm

    #1674695

  • RE: SYNTAX Help please...

    ScottPletcher (12/18/2013)

    Lynn Pettis (12/18/2013)

    Lynn Pettis (12/18/2013)

    Luis Cazares (12/18/2013)

    ScottPletcher (12/18/2013)

    Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being...

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

    December 18, 2013 at 8:17 pm

    #1674694

  • RE: GETUTCDATE() return null

    I take that back... that's actually an illegal form of update that will sometimes work and sometimes not. I'll explain more after I see the rest of the code...

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

    December 18, 2013 at 8:14 pm

    #1674693

  • RE: GETUTCDATE() return null

    ali.m.habib (12/18/2013)

    I have trigger after Insert that update field in the table with GETUTCDATE() but after Insertion I see the value = null

    SET NOCOUNT...

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

    December 18, 2013 at 8:12 pm

    #1674692

  • RE: Pass SSIS Object to child SSIS package

    Nice trick. It's also another notch on a 2x4 list of reasons why I try to do everything in T-SQL. 😉

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

    December 18, 2013 at 8:11 pm

    #1674691

  • RE: Need help with 2 query plans

    sgmunson (12/18/2013)

    That's really interesting behavior, and quite an improvement in the optimizer. Although, I wonder if, having figured out that SQL 2014 will start to allow you 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)

    December 18, 2013 at 7:59 pm

    #1674689

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    ScottPletcher (12/18/2013)

    If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than having a dopey, useless...

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

    December 18, 2013 at 7:49 pm

    #1674686

  • RE: Running a sqlcmd from Remote Machine

    Which C: drive are you trying to write to? It's not going to write to your local C: Drive from a remote machine. You need to use UNCs...

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

    December 18, 2013 at 7:45 pm

    #1674684

  • RE: Data truncation on MAX column through linked server

    Paul White (12/18/2013)

    Jeff Moden (12/18/2013)

    Voted up. Waiting for the normal response of "Closed - Will not fix". 😉

    Also up-voted and marked as reproducible. Wrong-results bugs usually get a high...

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

    December 18, 2013 at 7:33 pm

    #1674682

  • RE: Need help in SP

    Zohaib Anwar (12/18/2013)

    Hi All I have following two stored Procedures and I want to create 3rd one which will take the values of both 1st and 2nd SPs and Subtract...

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

    December 18, 2013 at 1:53 pm

    #1674618

  • RE: Need help in SP

    amy26 (12/18/2013)

    So, wherever you go...there you are? 😀 Hehe, sorry couldn't resist. 🙂

    DBCC TIMEWARP on sterioids. '-)

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

    December 18, 2013 at 1:29 pm

    #1674611

  • RE: Multiple Cases

    sharonsql2013 (12/18/2013)

    I need to count all the records that meet the conditions in the case statement.

    Following is the select after the CTE1 to display the count if each of 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)

    December 18, 2013 at 1:25 pm

    #1674609

Viewing 15 posts - 25,096 through 25,110 (of 59,102 total)