Forum Replies Created

Viewing 15 posts - 2,311 through 2,325 (of 2,766 total)

  • RE: Creating history audit table data

    Brandie Tarvin (8/17/2010)


    If you can piggy-back your logging table stuff on the code that actually inserts the original data into the table, that would be the best of all worlds,...

  • RE: Creating history audit table data

    Brandie Tarvin (8/17/2010)


    Does it have to be a trigger?

    If you're asking if my code has to be in a trigger, then no, it doesn't. In fact, the original version...

  • RE: Creating history audit table data

    Okay, I think I see what you're saying. Let me make sure I'm following this correctly.

    • Grab the rows from the inserted/deleted table and OUTPUT them into a table variable.
    • Get...

  • RE: Creating history audit table data

    Somewhat. One thing that's confusing me: is OUTPUT only limited to storing in a table variable, or is there a way for me to...

  • RE: Fantasy football

    Dan H. (8/17/2010)


    Woot....so by my count, that's 13 of us (if Ray K. is in)

    Oh, what the heck. Go ahead and count me in.

  • RE: Are the posted questions getting worse?

    Hi guys -- I could use some help on my question over here, if anyone has any thoughts!

  • RE: simple mathematical expressions

    HJC36 (8/17/2010)


    I have three different sets of data:

    A) = Total Qty on Hand (IC_QUANTITY)

    B) = Sum of demand for that inventory (sum(Fields!INPUT_QTY_STD.Value))

    C) = sum of the amount of that inventory...

  • RE: simple mathematical expressions

    Can you provide some sample data -- what you're working with, and how you want it to look?

  • RE: Today's Random Word!

    Impervious

  • RE: Today's Random Word!

    dbowlin (8/16/2010)


    Ray K (8/16/2010)


    dbowlin (8/16/2010)


    The real problem with Friday the 13th, is Monday the 16th. Argh!

    Hey Dan, I went to the ValleyCats game on Saturday, and they showed your...

  • RE: Today's Random Word!

    unsurmountable

  • RE: Identifying a trigger

    Yep, I just conferred with my boss (who is a DBA), and he gave me something very similar. I'll mess around with it and see what I can do...

  • RE: Today's Random Word!

    dbowlin (8/16/2010)


    The real problem with Friday the 13th, is Monday the 16th. Argh!

    Hey Dan, I went to the ValleyCats game on Saturday, and they showed your face up on...

  • RE: WHERE 1 = 1

    Michael Valentine Jones (8/13/2010)


    It is a way to create an endless loop that you will exit using the BREAK command, instead of when the test condition is true.

    while 1=1

    begin

    <Do something>

    if...

  • RE: WHERE 1 = 1

    Actually, your question is not as bad as you think it is! 😉

    As far as I know, this is used for testing . . . the clause "where 1...

  • Viewing 15 posts - 2,311 through 2,325 (of 2,766 total)