Forum Replies Created

Viewing 15 posts - 52,636 through 52,650 (of 59,098 total)

  • RE: Datediff usage

    Don Bernstein (2/11/2008)

    unless you think that SqlServer may some day refuse to convert the Datediff result to a datetime field

    That's kind of what I'm thinking... doesn't take much extra time...

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

    February 11, 2008 at 4:14 pm

    #777125

  • RE: Extended Procedure

    Could it be that simple? Your original post said you added an extended sp called "xp_add" yet in your latest post you say you are using "xp_add1". Do...

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

    February 11, 2008 at 4:08 pm

    #777121

  • RE: Generating Missing Dates and Numbers

    John Beggs (2/11/2008)

    I don't know why I didn't think of this last week, but the problem (in my case) was in the database compatability level. I was working in...

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

    February 11, 2008 at 4:01 pm

    #777117

  • RE: trigger problem

    Print commands, like rowcounts, can sometimes be made to bubble up through the app.

    However, I agree... I prefer to use Raiserror properly rather than the likes of PRINT......

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

    February 11, 2008 at 3:54 pm

    #777114

  • RE: Should DBA's need to know the physical details of a SAN??

    ALZDBA (2/11/2008)

    Learn to work together with your SAN-admin(s).

    Don't exceed thier level, but hand over the needed hints, so they can figure out for themselves your guidance makes sence !...

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

    February 11, 2008 at 7:10 am

    #776887

  • RE: Narrow down the recordset

    Ok... what would you do to return more information from each row using that method?

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

    February 11, 2008 at 6:50 am

    #776877

  • RE: trigger problem

    Heh... I guess I get carried away a bit on the "little" stuff, Johan. 😉 But, you're correct... it's a crucial error that both Newbies and those that write...

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

    February 11, 2008 at 6:42 am

    #776871

  • RE: Generating Missing Dates and Numbers

    Dunno what to say... like I said, the following code which you posted, works fine on my machine... no errors of any sort...

    [font="Courier New"];WITH T1 AS

    ( SELECT CAST('2007-01-01' AS DATETIME)...

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

    February 11, 2008 at 6:30 am

    #776866

  • RE: Temp Tables and Dynamic SQL

    Of course, not being always swayed by "official" documentation, I've tried it... only to be frustrated by the very same error messages as Kalhara was. I'd have to agree...

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

    February 10, 2008 at 7:44 pm

    #776792

  • RE: Extended Procedure

    Ok... understood...

    Run the following query from SSMS and let's make sure that the "server" (your Developer's Edition) can see the file...

    EXEC master..xp_fileexist 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll'

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

    February 10, 2008 at 3:45 pm

    #776785

  • RE: Extended Procedure

    I know... you said that before...

    WHICH MACHINE is that on! Is it on the SQL Server or on your DESKTOP computer?

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

    February 10, 2008 at 12:57 pm

    #776775

  • RE: Temp Tables and Dynamic SQL

    Now we're talking! Verifiable documentation from MS (usually) works for me! Thanks, Chris!

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

    February 10, 2008 at 12:56 pm

    #776774

  • RE: Generating Missing Dates and Numbers

    Heh... maybe the 3rd time will be the charm...

    PLEASE copy and paste the exact error you're getting... I get no errors when I run the code you posted in 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)

    February 10, 2008 at 11:01 am

    #776764

  • RE: trigger problem

    I'm going to say this so that everyone gets the point... 😉

    No, No, No, No!!!!

    Now that I have your attention, the reason why I'm being so adamant is because...

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

    February 10, 2008 at 10:23 am

    #776761

  • RE: Temp Tables and Dynamic SQL

    All good replies... but they all seem to miss the mark a bit. This question seems to be more about what you can and cannot do with variables in...

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

    February 10, 2008 at 9:55 am

    #776758

Viewing 15 posts - 52,636 through 52,650 (of 59,098 total)