Forum Replies Created

Viewing 15 posts - 52,516 through 52,530 (of 59,072 total)

  • RE: Sequential numbering issue

    --===== Create a test table with data

    -- THIS IS NOT PART OF THE SOLUTION

    DECLARE @YourTable TABLE (DocNo VARCHAR(20),LiNum INT)

    INSERT INTO @YourTable (DocNo,LiNum)

    SELECT 'ZC12345',1...

    --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 15, 2008 at 12:24 pm

    #778976

  • RE: Help with formating

    So, maybe write some code that writes code for you?

    Also, you can set the results in the text mode to use the TAB character to separate columns to make 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 15, 2008 at 12:01 pm

    #778966

  • RE: Help with formating

    DOH! (making thumbsucking noises and triddling hair)... sometimes I just get balled up on things. Of course, Greg!... Nice simple solution like that is the way to go....

    --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 15, 2008 at 11:00 am

    #778940

  • RE: Datatype for US Money

    Matt S... yeaup... a bit "contrived" as you say... the example is meant to mimic the real world where people forget what datatype they're using to do calculations and 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 15, 2008 at 10:50 am

    #778935

  • RE: Datatype for US Money

    GSquared (2/15/2008)

    Even in that case, using float instead of decimal resulted in a measureable speed increase. (I have to calculate distances between sets of up to 4-million records 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)

    February 15, 2008 at 8:41 am

    #778869

  • RE: Datatype for US Money

    Caught me? Heh... I jumped right out in front of ya 😀

    What you say is similar to what I used to say and 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)

    February 15, 2008 at 8:38 am

    #778867

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

    ALZDBA (2/15/2008)

    Well it certainly started with a great article, handling a fairly common issue 😎

    And it resulted in a solution that worked a lightning speed and performed

    the actual update 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 15, 2008 at 7:45 am

    #778841

  • RE: Datatype for US Money

    Ross McMicken (2/15/2008)

    The biggest issue we've had with using money datatypes is that reports in Crystal, and other tools, put a $ sign on each foeld by default. Given tha...

    --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 15, 2008 at 7:24 am

    #778832

  • RE: Datatype for US Money

    matt stockham (2/14/2008)

    I would say use whatever datatype is appropriate - if the potential range of stored values falls within smallmoney then go for it. Decimal is useful 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 15, 2008 at 7:15 am

    #778825

  • RE: The switch to Oracle

    A primary key of more than 16 columns... Lordy, I sure hope someone doesn't think of that as "core" functionality... :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)

    February 14, 2008 at 9:51 pm

    #778704

  • RE: Datatype for US Money

    So... what would you do with 99.99 shares and 4 people? Decimal isn't going to hack that, either.

    Implementation of float in your 3 person case would be as follows...

    DECLARE...

    --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 14, 2008 at 9:42 pm

    #778698

  • RE: Help With Query

    Thanks, Aaron...

    --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 14, 2008 at 9:29 pm

    #778692

  • RE: Bulk insert question

    Now I don't know .. is replacing of temporary tables with table variables worth it or not?

    Absolutely NOT...

    And, I agree with Matt... your co-worker doesn't know what he/she is talking...

    --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 14, 2008 at 9:11 pm

    #778685

  • RE: Help with formating

    The columns are self sizing... makes real pretty emails... you send an email with the file as an attachment.

    ie... SUBJ: Your daily report on whatever is attached.

    Now,...

    --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 14, 2008 at 8:29 pm

    #778680

  • RE: get nextid for non-identity column

    In other words, please see the following URL...

    http://www.sqlservercentral.com/Forums/Topic418139-8-1.aspx#bm418200

    ...and don't worry... provided you call it correctly and learn how to use the "Increment" as I've laid out in the URL above,...

    --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 14, 2008 at 8:02 pm

    #778677

Viewing 15 posts - 52,516 through 52,530 (of 59,072 total)