Forum Replies Created

Viewing 15 posts - 57,451 through 57,465 (of 59,098 total)

  • RE: Generic Audit Trigger

    Yep... First, I changed the function to capture the data type... again, you'll need to change the name of the function...

     CREATE FUNCTION dbo.fnColumnsUpdated

            (@TableName SYSNAME, @BinaryColNums VARBINARY(128))

            RETURNS...

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

    October 12, 2006 at 7:21 am

    #665469

  • RE: Log file

    THAT would certainly be a limit, huh?   Yeah, I know they reached the end but then they said they'd limit it to 300...

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

    October 11, 2006 at 10:41 pm

    #665369

  • RE: OSQL echoing to outputfile

    Mr B... PRINT is exactly what you are looking for... if you don't want the rowcounts to show up in "standard" format, you can do a SET NOCOUNT ON 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)

    October 11, 2006 at 10:10 pm

    #665362

  • RE: Looking for a good Database Design guide

    Books Online... comes free qith SQL Server... lookup "Database Design" (I think)...

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

    October 11, 2006 at 10:05 pm

    #665361

  • RE: Sum on a row

    Mark left out one part and if you did, too, you WILL get the same results... your GROUP BY has to be by the same formulas that Mark gave 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)

    October 11, 2006 at 10:03 pm

    #665360

  • RE: Query Running Slow

    Outstanding list, Rudy... I'd like to bump your rounds down 1 and add a new round 1... "Write scalable code to start with."

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

    October 11, 2006 at 9:59 pm

    #665357

  • RE: Script Field formats.

    Don't think that's quite what Nick meant...

    Nick... You can do this by creating your view like this....

     CREATE VIEW dbo.someviewname AS

     SELECT CAST(dflt_cyl_ctf AS DECIMAL(18,4)) AS dflt_cyl_ctf,

            CAST(cyl_ctf_actv AS INT)...

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

    October 11, 2006 at 9:51 pm

    #665356

  • RE: Log file

    As some have correctly suggested, unless you do backups everyday, you should have the "recovery mode" set to SIMPLE.

    DO NOT LIMIT THE LOG FILE!!!  IF IT TRYS TO GROW BEYOND...

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

    October 11, 2006 at 9:44 pm

    #665354

  • RE: Generic Audit Trigger

    Ok... first, thank you very much for making my life easier for testing... the good news is, I get no errors with the following test code.  The bad news 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)

    October 11, 2006 at 9:28 pm

    #665350

  • RE: Generic Audit Trigger

    Hmmmm.... I'm wondering if the error I got when I ran you build scripts might be a hint of your DELETE problem...

    Warning: The table 'AuditDetail' has been created...

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

    October 11, 2006 at 8:46 pm

    #665348

  • RE: Trigger issue

    Understood and appreciate the feed-back but riddle me this... did you change your code so that it does NOT use an UPDATE, yet 

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

    October 11, 2006 at 8:28 pm

    #665347

  • RE: Split a field into multiple records

    Paul Cresham's function is great... I have a similar one that uses a Tally table... thought you might enjoy seeing it... the documentation is longer than the function itself...

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

    October 11, 2006 at 8:21 pm

    #665346

  • RE: Pass a value to a trigger...

    Peter,

    Thanks for being patient with the explanation...  It would be really nice to combine both methods so that if something other than your proc fires the trigger, you can still...

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

    October 11, 2006 at 7:38 pm

    #665343

  • RE: Trigger issue

    Yep, sorry about that... I got a little frustrated with you... everyone has been trying to tell you that you're asking for "Death by SQL" by doing the UPDATE right...

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

    October 11, 2006 at 8:29 am

    #665234

  • RE: syntax error.

    There's really no physical problem to keep you from using it... However, Microsoft and a bunch of folks on this forum have indicated that in order to guarantee that your...

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

    October 11, 2006 at 7:27 am

    #665207

    • Viewing 15 posts - 57,451 through 57,465 (of 59,098 total)