Forum Replies Created

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

  • 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

  • RE: How do I extract information from a string

    If the formatting of each element is pretty much cast in stone, then a straight forward method may be in order...

    Here's the test data...

    --===== Create a demonstration table (This is...

    --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:14 pm

    #960794

  • RE: BULK INSERT problems

    It's going to be tough to troubleshoot this without some test data and a listing of the code that does the Bulk Insert. If the data has private 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 16, 2009 at 10:20 pm

    #960781

  • RE: comparing results of 2 views

    harish_ravi (3/16/2009)

    Thanks for your reply. i verified it was working gr8.

    but i dont think its working for comparing data with duplicate values.

    like the below.

    DECLARE @v1 TABLE (id INT, txt VARCHAR(100))

    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)

    March 16, 2009 at 10:17 pm

    #960780

  • RE: NEED HELP URGENT (MLB)

    Heh... "Survey says... ding, ding, ding, ding, ding... STUFF! Look it up in Books Online". Bruce is spot on.

    --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 10:08 pm

    #960777

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