Forum Replies Created

Viewing 15 posts - 44,581 through 44,595 (of 59,097 total)

  • RE: How to differentiate (Field containing comma) in csv file while using bulk insert

    Adi Cohn (3/15/2009)

    You can find an explanation here – http://msdn.microsoft.com/en-us/library/ms191516(SQL.90).aspx

    Adi

    Unfortunately, the MS documentation on this subject doesn't tell you how to handle text qualified strings that use quotes with...

    --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, 2009 at 9:11 am

    #959902

  • RE: T-Sql rant

    steve dassin (3/14/2009)

    foxjazz (3/13/2009)

    Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending 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 15, 2009 at 9:08 am

    #959901

  • RE: String Manipulation

    Jack Corbett (3/15/2009)

    Barry,

    Just making sure you noticed, but Goldie said that the CLR is not an option in this case. I had suggested it originally as well.

    Heh... yeah... but...

    --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, 2009 at 9:02 am

    #959898

  • RE: Small server - any point in 64bit?

    I'll also kick in that I'm amazed at the attitude of so many DBA's, especially System DBA's. The code is part of the server and bad code should be...

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

    #959896

  • RE: Are the posted questions getting worse?

    RBarryYoung (3/14/2009)

    OK, this is the most disturbing thing that I have read in a while. Read it closely. Brrrr...

    Oooooh myyyyyy.... absolutely chilling. "Forgive them, Lord, for they...

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

    #959872

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    I haven't experienced a case where I could write a stored proc, without t-sql language .... I would love to write my stored procs in c#.

    foxjazz (3/14/2009)

    Its really sad...

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

    #959871

  • RE: String Manipulation

    RBarryYoung (3/14/2009)

    Jeff Moden (3/14/2009)

    RBarryYoung (3/14/2009)

    I know that this'll drive Jeff crazy, but I actually think that this would work better as a CLR Trigger.

    It might... but Nah... "we don need...

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

    #959869

  • RE: String Manipulation

    Here's the code with the last step of counting the actual words...

    --===== Replace all HTML tags with nothing

    WHILE CHARINDEX(' CHARINDEX('<',@HTMLText)

    SELECT @HTMLText = STUFF(@HTMLText,

    ...

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

    #959868

  • RE: String Manipulation

    Sorry Goldie... I forgot the last step... I'll be right back...

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

    #959865

  • RE: String Manipulation

    RBarryYoung (3/14/2009)

    I know that this'll drive Jeff crazy, but I actually think that this would work better as a CLR Trigger.

    It might... but Nah... "we don need no stinkin' CLR"...

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

    #959863

  • RE: String Manipulation

    As much as I praise their use, there are some things that the Tally table won't beat a WHILE loop at... cleaning strings using STUFF is one of those things...

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

    #959861

  • RE: String Manipulation

    Goldie Graber (3/14/2009)

    Download the file and save as text.

    If you try to view it in your browser it will translate the HTML tags.

    Ack... of course... stupid me. Thanks, Goldie.

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

    #959851

  • RE: Update query is killing me..

    Joseph (3/14/2009)

    if you want you can try using Common Table Expression (CTE) method.. ans see how long it will take

    WITH CITY_INFO(stateid ,cityid,districtid,distpt,citypt

    (

    select stateid ,

    ...

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

    #959850

  • RE: t-sql dates

    Bob Hovious (3/14/2009)

    Sorry I didn't post my code. There's nothing secret about it, but Rob requested it in PM and I respected his request. ...

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

    #959849

  • RE: T-Sql rant

    lmu92 (3/14/2009)

    @ Jeff:

    Jeff Moden (3/14/2009)

    Heh... definitely not. English only here.

    I wouldn't be so sure about that... 😛

    Heh... sorry... the "here" means "me" in this case. I understand...

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

    #959848

Viewing 15 posts - 44,581 through 44,595 (of 59,097 total)