Forum Replies Created

Viewing 15 posts - 54,391 through 54,405 (of 59,072 total)

  • RE: DTS is extreamly slow to transfer data for just 1 small table. Please help!

    Check for triggers, as well.

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

    October 27, 2007 at 11:31 pm

    #746030

  • RE: SQL query need help!!! urget

    C'mon man... do your own homework... you haven't even tried...

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

    October 27, 2007 at 11:29 pm

    #746029

  • RE: Clarity vs Speed

    Heh... ok... guess I'll get up on the soap box, then...

    ALWAYS use the fastest, most effecient code possible... ALWAYS use comments to explain the code unless it's just too, too...

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

    October 27, 2007 at 7:07 pm

    #746021

  • RE: Date

    Jason certainly had the right idea... and this goes just a bit further for forcing a format... but it's not 100% bullet proof...

    DECLARE @test-2 TABLE (SomeDate VARCHAR(20))

    INSERT INTO...

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

    October 27, 2007 at 6:59 pm

    #746019

  • RE: Date

    I agree with Jason... I think ISDATE, by itself, is a very bad way to check for valid dates. For example, the following all return "1" using ISDATE...

    [font="Courier New"]SELECT...

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

    October 27, 2007 at 5:55 pm

    #746018

  • RE: Excel Import using DTS

    Any import will fail if someone has the sheet open... in my opinion, best way to do this is to make a macro on the spreadsheet to export the correct...

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

    October 27, 2007 at 1:22 pm

    #746016

  • RE: More junk with dates

    David,

    "Dropping the time" should be done on the display side of things... not on the import side of things. Reason being is that the only way you can truly...

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

    October 27, 2007 at 1:19 pm

    #746015

  • RE: Problem with UDF

    But I am still curious as to why my UDF didn't work.

    Your UDF works... but think about it... what do you get when you concatenate a NULL 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)

    October 27, 2007 at 9:09 am

    #745992

  • RE: Problem with UDF

    Just a personal opinion...

    I think you may be trying to do too much in a UDF. I think the UDF should do nothing but find the number you're looking...

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

    October 27, 2007 at 8:37 am

    #745990

  • RE: Multiple values on y-axis?

    The picture of what you wanted in your first post is not visible.

    Layout some text on the next post that depicts the format that you would like. Use 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)

    October 27, 2007 at 8:32 am

    #745989

  • RE: extract yesterdays info without failures.

    I'm thinking this is wrong...

    SELECT * FROM IPGDB..SHPHST

    WHERE SIDATE > '2007-10-16'

    AND SIDATE <= '2007-10-17'

    Should be...

    SELECT * FROM IPGDB..SHPHST

    WHERE SIDATE >= '2007-10-16'

    AND SIDATE < '2007-10-17'

    Other than that, your transaction is pretty...

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

    October 26, 2007 at 7:45 pm

    #745951

  • RE: Formatting the date

    Kenneth Wilhelmsson (10/26/2007)

    Actually, there's nothing incorrect about any of these.

    SQL Server is very obedient and sorts exactly as asked to..

    ...if that wasn't exactly what one intended, is another matter..

    The 'fault'...

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

    October 26, 2007 at 7:39 pm

    #745950

  • RE: Pulling Strings from larger string.

    How would you like to import 5 million rows in about a minute? Post, say, 100 rows of data as an attachment and I'll show you how to build...

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

    October 26, 2007 at 7:35 pm

    #745949

  • RE: Sequential Update

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

    October 26, 2007 at 7:10 pm

    #745948

  • RE: convert from MM/DD/YYYY to YYYYMMDD

    bharani (10/23/2007)

    ya, but my team want that to be an int value...

    Your team is absolutely wrong... Peter Larson has a good viable solution... storing any date or time as other...

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

    October 26, 2007 at 5:38 pm

    #745942

Viewing 15 posts - 54,391 through 54,405 (of 59,072 total)