Forum Replies Created

Viewing 15 posts - 54,421 through 54,435 (of 59,098 total)

  • 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

  • RE: Clarity vs Speed

    Heh... no matter how you swing it, this whole thing is RBAR... if it's for a GUI single row proc... no problem... if it even comes near a batch, big...

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

    #745941

  • RE: Editorial control on columnists

    Heh... the only thing I might disagee with is you calling Celko "smart" 😉

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

    #745940

  • RE: Unstring text field?

    Bob Bridges (10/24/2007)

    Jeff,

    You got me on the right track... the problem is in the "SET @col" statement. I had

    SET @col = 'Part2.Part1'

    What I didn't realize is that the "Part2"...

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

    #745939

  • RE: Sequential Update

    MrPoleCat,

    Would you be kind enought to test this on your SQL Server 7? Thank you, Sir...

    --===== If the test table already exists, drop it

    IF...

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

    #745937

Viewing 15 posts - 54,421 through 54,435 (of 59,098 total)