Forum Replies Created

Viewing 15 posts - 47,491 through 47,505 (of 59,102 total)

  • RE: The October 2008 Energy Update

    Heh... the problem with the indecision that some face as to who to vote for is simple... which idiot will cause the least amount of damage? 😛

    If you want...

    --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 31, 2008 at 9:51 pm

    #892673

  • RE: Subquery and Join (Speed)

    There's virtually no difference between a JOIN and an IN (subquery)... they will both create the same execution plan and execute within milliseconds of each other... unless there's a correlation...

    --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 31, 2008 at 9:18 pm

    #892669

  • RE: varchar error

    Matt Miller (10/31/2008)

    "Must look Eye"

    Heh... yeah... I forgot to add that on... 😛 So many cars... so little wax. :hehe:

    --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 31, 2008 at 9:09 pm

    #892667

  • RE: Implement Data integrity

    Muralidharan Venkatraman (10/31/2008)

    :(I have a production application which holds 100+ tables which does not have primary keys at all and running in sql server 2005. I inherited this application 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 31, 2008 at 9:02 pm

    #892664

  • RE: Is a Recursive Query what I need?

    Nicely done! And thanks for the feedback especially on the performance/durations.

    My only concern is the BEGIN/COMMITs you have for Stages 1 through 4... the [CPMTEST].[XJASN4N].[tblCLS_OFSA] is 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 31, 2008 at 8:50 pm

    #892663

  • RE: varchar error

    ry.rith (10/31/2008)

    Thank so much,

    that you tell me about the solution.

    I also do the same of yours to complete the crosstab-report, but something that i want is to know why it's...

    --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 31, 2008 at 8:22 pm

    #892658

  • RE: SQL Cursor problem

    Heh... I've just gotta agree with that! 😛

    --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 31, 2008 at 8:05 pm

    #892656

  • RE: compressing / collapsing numbers

    juergen.kessler (10/31/2008)

    @Seth: Sorry Seth, will follow you next time.

    If you do it this time, you'll actually get a tested answer... 😉

    --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 31, 2008 at 7:57 pm

    #892652

  • RE: Query data with manipulation

    jack_hc (10/30/2008)

    Hi,

    I am facing a problem to extract data from a table, the table contains over 41k records, and some of them(>5k) share same column value, now what i am...

    --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 31, 2008 at 7:45 pm

    #892650

  • RE: Update Trigger questions / multiple rows in "inserted" table

    Mark Rissmann (1/30/2007)

    IF UPDATE(VendorCode)

    BEGIN

    UPDATE vendor SET vendorcode=inserted.vendorcode

    FROM inserted JOIN deleted ON inserted.vendorID=deleted.vendorID

    WHERE (inserted.vendorcode <> deleted.vendorcode) AND (inserted.iscopy=0) AND (inserted.ID =...

    --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 31, 2008 at 7:37 pm

    #892649

  • RE: CPU usage 100%

    Search the web for "CDONTS"

    --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 31, 2008 at 7:35 pm

    #892648

  • RE: custom start day of week

    It's a good thing to have, anyway... make a Calendar table based on the user inputs.

    --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 31, 2008 at 7:25 pm

    #892646

  • RE: Merging duplicate rows

    sam (10/31/2008)

    How can I merge the rows with the duplicate or common custnumbers, amounts and semesters?

    e.g. row 4 and 5 have a common custnumber, amount and semester so i want...

    --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 31, 2008 at 7:18 pm

    #892644

  • RE: compacting a numbered list

    dlongnecker (10/31/2008)

    Hey everyone,

    I've got a table with a column of ints and I need to remove any discontinuity between them...

    Although PW's post is spot on, I suspect there's a bigger...

    --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 31, 2008 at 7:09 pm

    #892643

  • RE: Clr Trigger for Insert

    anupamabr (10/31/2008)

    thanks for your quick response ..eventhogh i changed the code it didnt work

    Do you mean that you changed it to 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)

    October 31, 2008 at 7:07 pm

    #892642

Viewing 15 posts - 47,491 through 47,505 (of 59,102 total)