Forum Replies Created

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

  • RE: Generic Audit Trigger

    I guess I'm just going to have to materialize this code and test it...

    Would you post the CREATE TABLE statement for the two audit tables and the CREATE FUNCTION...

    --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:21 am

    #665203

  • RE: How to do a Select xx from

    And, you need to be real careful if this comes anywhere near a GUI... think "SQL Injection".  Theres a huge amount of info on how to prevent it... do 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)

    October 11, 2006 at 7:15 am

    #665200

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

    I guess I don't understand... obviously, you are finding the correct Windows user name somewhere along the line in your stored procedure because you want to "pass it" to 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)

    October 11, 2006 at 7:11 am

    #665199

  • RE: syntax error.

    It's the triple quotes in the variable assignment that are the most recent problem...

    Try this...

    declare @townID varchar(25),

         @sql varchar(1000)

    set @townID = '00003' --<<THIS IS WHERE 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)

    October 11, 2006 at 6:49 am

    #665194

  • RE: Count Decimal Places

    Old guys rule...   1 million conversions... 11 seconds... works for positive numbers, negative numbers, zero, and NULL...

    DECLARE @Places INT

     SELECT TOP 1000000...

    --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 1:51 am

    #665149

  • RE: Trigger issue

    If you run this code, you might just want to have your DBA turn on Trace Flag 1204 just to be safe

    --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 10, 2006 at 11:43 pm

    #665133

  • RE: Generic Audit Trigger

    Ok... here it is... sans cursors... just so you know, I have NOT tested this particular code. 

    There are a couple of other things you need to know...

    1. You need 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)

    October 10, 2006 at 11:24 pm

    #665131

  • RE: Generic Audit Trigger

    Oh jeez... If you're going to insult me with a cursor

    Just kidding a bit... lemme see what I can do... I'll be 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)

    October 10, 2006 at 7:33 pm

    #665113

  • RE: Generic Audit Trigger

    William is correct... if you update a column to the same value, it will register as being updated even though it has the same value... it's up to your 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)

    October 10, 2006 at 7:26 pm

    #665112

  • RE: Converting to int and aggregating at the same time

    You can use the PatIndex if you want... I prefer the regular expressions because they seem to be simpler and they run with good speed...

    For example, if you had...

    --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 10, 2006 at 6:26 pm

    #665107

  • RE: Generic Audit Trigger

    Dang... fat fingered that one   Meant to say that the deleted table is empty for INSERTs... thanks for the catch, 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)

    October 10, 2006 at 7:19 am

    #664993

  • RE: Split a field into multiple records

    First... replace all the CHAR(13) occurances with ';' including the single quotes.  Some use similar code to make a function where they can pass the delimiter to the function 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)

    October 10, 2006 at 6:26 am

    #664979

  • RE: Self Eliminated Parameters

    Maybe that's the difference... I'm running SQL Sever 2000 Enterprise Edition with SP4.  Just kidding... I get the same execution plans on an SP3a box as well.  I don't know...

    --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 10, 2006 at 6:20 am

    #664978

  • RE: What makes it faster?

    • quote

    As a self-taught newbie, I guess when it comes to the "religion", I don't have a lot 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)

    October 10, 2006 at 6:15 am

    #664976

  • RE: What makes it faster?

    My managers at work liked it so well, they allowed the term in our coding standards... and, ALL the developers know what RBAR means... no need for a lengthy explanation...

    --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 10, 2006 at 6:10 am

    #664973

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