Forum Replies Created

Viewing 15 posts - 44,596 through 44,610 (of 59,101 total)

  • 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

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

    megham10 (3/13/2009)

    Hi All,

    I 'm Using Bulk insert Statement to load .CSV File into temp table.

    one of my field contains data as eg."23,446" so while inserting it treats it as two...

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

    #959846

  • RE: Issue with CTE

    Bob Hovious (3/12/2009)

    I think we've caught Moden's Millisecond Madness.

    Heh... you must have... you're getting good at it. 😉

    The performance key here isn't the number of milliseconds of difference between 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)

    March 14, 2009 at 9:05 pm

    #959845

  • RE: Issue with CTE

    Heh... stupid me... of course it's set to 9 or you'd have gotten a message about the CTE. Sorry.

    Can you post your final code? I just wanna make...

    --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 8:59 pm

    #959844

  • RE: Issue with CTE

    siddartha pal (3/12/2009)

    I am not able to complie the function because of Varchar(max) for @string parameter.

    Siddartha,

    Check the compatibility level of the database... if it's set to "8", then the database...

    --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 8:28 pm

    #959842

  • RE: Where do I start?!

    WebTechie38 (3/14/2009)

    How do you slow the boss down to document the environment, plan backups and develop a test environment when he hired you for all the "NEW" stuff for 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)

    March 14, 2009 at 8:13 pm

    #959837

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Why not have t-sql be capable of merging with other languages by preference?

    Heh... I told you that it actually is, before... you can write all your stored procedures 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)

    March 14, 2009 at 8:05 pm

    #959833

  • RE: T-Sql rant

    Heh... definitely not. English only here. Of course, if I need something done in Germany, I get a translator.

    Same goes with code... GUI programmers shouldn't have...

    --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 8:01 pm

    #959832

  • RE: String Manipulation

    Goldie Graber (3/14/2009)

    Jeff Moden (3/14/2009)

    Hi Goldie...

    Not sure I can help but it would make it easier to try if you attached a file that has an example HTML 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 14, 2009 at 7:43 pm

    #959830

  • RE: T-Sql rant

    RBarryYoung (3/14/2009)

    OK, foxjazz, now I have a question for you:

    foxjazz (3/14/2009)

    Ok, yes I did it that way before. Except you have to do it in 4 distinct query sets, 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)

    March 14, 2009 at 7:39 pm

    #959826

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Instead of having you guys try and figure out some problem without the use of cursors, I have already made my point without realizing that I had.

    Simply because cursors...

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

    #959822

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Ok, yes I did it that way before. Except you have to do it in 4 distinct query sets, and link the first results to the other set, 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)

    March 14, 2009 at 7:06 pm

    #959818

Viewing 15 posts - 44,596 through 44,610 (of 59,101 total)