Forum Replies Created

Viewing 15 posts - 39,316 through 39,330 (of 59,098 total)

  • RE: T-SQL: Why “It Depends”

    The Dixie Flatline (3/16/2010)

    Jeff: Simply thanks. I've told you before at length how much I owe you. It's good not to be savaged...

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

    March 16, 2010 at 7:02 am

    #1134406

  • RE: Add business days to a date field

    sturner (3/12/2010)

    sure, shoot me a private message with an email address.

    Nah... do here... in the open where everyone can learn.

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

    March 15, 2010 at 10:47 pm

    #1134250

  • RE: Concurrent instances of stored procedures

    I have a requirement to run a stored procedure that does a lot of heavy processing.

    I agree with Jeffrey above. I'll add that anytime I see the words "heavy...

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

    March 15, 2010 at 10:23 pm

    #1134239

  • RE: Computed Column Help Please

    Along with all the other problems people have stated (some having legal impact), the "code" also violates a couple of normal forms because it records 3 different pieces of information...

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

    March 15, 2010 at 9:40 pm

    #1134225

  • RE: what is the most efficient way to maintain a denormalized table?

    15 Hours? It would appear that, in your case, denormalization for reporting puposes is the wrong thing to do. I'd consider a more normalized approach that uses performance...

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

    March 15, 2010 at 9:23 pm

    #1134216

  • RE: Splitting A String

    jarjarlee (3/15/2010)

    You should use a funcation.

    define a funcation like

    CREATE FUNCTION [dbo].[SplittingByDot]

    (

    @SourceData varchar(255)

    )

    RETURNS NVARCHAR

    AS

    BEGIN

    ......

    END

    then use the

    SELECT dbo.SplittingByDot(OutlineNumber) FROM dbo.Tally

    get the result

    Other than...

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

    March 15, 2010 at 8:58 pm

    #1134210

  • RE: select random records but for each category

    mister.magoo (3/15/2010)

    There is another problem with the previous solution

    Which previous solution? 🙂

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

    March 15, 2010 at 8:01 pm

    #1134200

  • RE: Manipulate Date Output

    monitor89 (3/15/2010)

    Got it figured out...

    Original

    substr(h.dob,5,2) || right(h.dob,2) || left(h.dob,4) as Birth_Date,

    New

    substr(h.dob,5,2) || '/' || right(h.dob,2) || '/' || left(h.dob,4) as Birth_Date,

    ...pretty easy actually.

    How about ...

    TO_CHAR(TO_DATE(h.dob,'yyyymmdd'), 'mm/dd/yyyy') AS Birth_Date

    😉

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

    March 15, 2010 at 7:55 pm

    #1134199

  • RE: Today's Random Word!

    Lynn Pettis (3/14/2010)

    snowshoes

    One Post. 😉

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

    March 15, 2010 at 7:36 pm

    #1134197

  • RE: Today's Random Word!

    Kit G (3/15/2010)

    But alas, intelligence is not a pre-requisite for becoming a pirate.

    BWAA-HAAA!!!! According to some of the posts I've seen lately, it's not essentially required to be 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)

    March 15, 2010 at 7:35 pm

    #1134196

  • RE: Facing Problem With Bulk Insert

    karthik -450760 (3/15/2010)

    Thanks Jeff. I have attached the text file. Below is my create table stmt and Bulk Insert Statement.

    Thanks Karthik... I have to ask though... is that an actual...

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

    March 15, 2010 at 7:18 pm

    #1134193

  • RE: Facing Problem With Bulk Insert

    steve-893342 (3/15/2010)

    Yes that's right Jeff, you wouldn't need a format file for BULK INSERT. It really depends how much flexibility you need. OPENROWSET BULK allows 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)

    March 15, 2010 at 7:15 pm

    #1134192

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/15/2010)

    You know ..... If the right "outsider" read the Thread, some of us might end up with free room and board for the rest of our lives, wall...

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

    March 15, 2010 at 7:00 pm

    #1134189

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (3/15/2010)

    bitbucket-25253 (3/15/2010)

    Lynn Pettis (3/15/2010)

    Grant Fritchey (3/15/2010)

    Lynn Pettis (3/15/2010)

    Grant Fritchey (3/15/2010)

    GSquared (3/15/2010)

    Grant Fritchey (3/15/2010)

    Oh cool, tossed under another bus. Thanks Alvin.

    What year? (My birthday was yesterday, so I'm...

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

    March 15, 2010 at 6:54 pm

    #1134185

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/15/2010)

    CirquedeSQLeil (3/15/2010)

    Alvin Ramard (3/15/2010)

    CirquedeSQLeil (3/15/2010)

    Lynn only needs 4 more posts for 10,000 posts (not overall pts).

    CountDown on?

    Got the tent ready for the party? D'you sweep out all...

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

    March 15, 2010 at 6:52 pm

    #1134183

Viewing 15 posts - 39,316 through 39,330 (of 59,098 total)