Forum Replies Created

Viewing 15 posts - 44,551 through 44,565 (of 59,101 total)

  • RE: T-Sql rant

    foxjazz (3/19/2009)

    I think this is the query I arrived at for getting the next PK value.

    select @currentval = max(Convert(int,substring(GenLevelAddFieldID,len(@@servername) + 1,10))) from tblLevelAddFieldRel where GenLevelAddFieldID like @@servername + '%'...

    --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 19, 2009 at 6:36 pm

    #963249

  • RE: T-Sql rant

    JacekO (3/18/2009)

    I would keep it simple. Deal with one record at a time. If your Stored Procedure is designed to work fine with one record you can call it sequentially...

    --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 18, 2009 at 8:59 pm

    #962450

  • RE: Are the posted questions getting worse?

    Derek Dongray (3/18/2009)

    ... that is, that light bulb is flickering on!

    Heh... either that or it's the low glow from a slow burning fuse... 😉

    --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 18, 2009 at 8:38 pm

    #962445

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/18/2009)

    Hey Jeff, can I send you an email about something?

    Always, Bob.

    --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 18, 2009 at 8:28 pm

    #962440

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/18/2009)

    I think all of you has made some progress with Fox. He actually gave the Table structure?? Wow. I am impressed with all of your patience..

    I cannot believe...

    --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 18, 2009 at 7:45 pm

    #962424

  • RE: BULK INSERT problems

    That's why I suggested attaching the first 10 lines of the file... so I can see what the termination character is in binary.

    --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 18, 2009 at 7:36 pm

    #962414

  • RE: is there a way to do a mass update in SSIS

    Thanks for the feedback... and yes, that's precisely what I was talking about. You also don't need to spend a lot of time deleting that way, either (although, like...

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

    #962411

  • RE: T-Sql rant

    foxjazz (3/18/2009)

    J, my dba wife pointed it out to me last night that set based solutions are not always superior to cursors.

    She's confusing things like the use of triangular...

    --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 18, 2009 at 7:14 pm

    #962404

  • RE: T-Sql rant

    Lynn Pettis (3/18/2009)

    Chris Morris (3/18/2009)

    foxjazz (3/18/2009)

    {} is much better than BEGIN BEGIN BEGIN BEGIN END END END END

    Heh quite possibly - but the count of BEGIN - END pairs goes...

    --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 18, 2009 at 7:06 pm

    #962400

  • RE: question, urgent please!!!

    BWAAA-HAAA!!!! Hey Lynn! Now you know one of the reasons I don't like case sensitive databases. 😛

    --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 17, 2009 at 6:49 pm

    #961521

  • RE: T-Sql rant

    Bob Hovious (3/17/2009)

    Knock rings about what? (This is not a sarcastic question, Jeff.)

    The Thread... if you want it to be a good place to meet for those 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)

    March 17, 2009 at 8:57 am

    #961114

  • RE: T-Sql rant

    You guys are starting to knock rings about that and that's not right.

    --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 17, 2009 at 5:45 am

    #960930

  • RE: T-Sql rant

    Sheesh!

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

    #960806

  • RE: T-Sql rant

    steve dassin (3/16/2009)

    you have my regret that I misjudged the maturity level of some readers here.

    Man... get over yourself... I used to respect your maturity until you started using cheap...

    --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, 2009 at 11:38 pm

    #960804

  • RE: Create View with Split Columns

    Bob Hovious (3/16/2009)

    Hal, my apologies.

    I thought perhaps there was a misunderstanding about the question. When I saw that Flo had answered to your satisfaction I...

    --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, 2009 at 11:20 pm

    #960795

Viewing 15 posts - 44,551 through 44,565 (of 59,101 total)