Forum Replies Created

Viewing 15 posts - 54,406 through 54,420 (of 59,089 total)

  • RE: Formatting the date

    Man, you talk a lot about nothing...

    First two sorts are incorrect because they did not sort in the desired order.

    --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 29, 2007 at 2:29 am

    #746106

  • RE: SQL query need help!!! urget

    Do you have a specific question or do you just want us to do all of your homework for you?

    You're in class to learn this stuff and these...

    --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 28, 2007 at 8:57 am

    #746053

  • 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

Viewing 15 posts - 54,406 through 54,420 (of 59,089 total)