Forum Replies Created

Viewing 15 posts - 56,986 through 57,000 (of 59,101 total)

  • RE: Day Range Caluculations

    Thanks Farrell,

    That's a high compliment coming from folks like yourself.

    Vamsi,

    On my way to work so can't answer in detail just now but, I need to know, what are the boundaries...

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

    February 6, 2007 at 6:25 am

    #688004

  • RE: Time Difference

    Nicely done, Robert.

    I'm still waiting for the original poster to definitely describe the datatype of the column he named "TimeStamp" (instead of guessing ).

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

    February 5, 2007 at 7:15 pm

    #687898

  • RE: Day Range Caluculations

    Ok, here's some sample code using Michael's function that I renamed as "fnTally" and changed the "Numbers" column to just an "N" to match what I also have in my...

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

    February 5, 2007 at 7:09 pm

    #687896

  • RE: Day Range Caluculations

    1) WHERE Name IS NULL - is that specific to your Master.dbo.spt_Values table? 

    It is specific to the Master.dbo.spt_Values table... however, the table isn't "my" table, it's part of...

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

    February 5, 2007 at 5:22 pm

    #687892

  • RE: Day Range Caluculations

    Same as above but single column output...

    DECLARE @StartDate DATETIME

    DECLARE @EndDate DATETIME

        SET @StartDate = '01/01/2006'

        SET @EndDate = '10/02/2007'

    PRINT DATEDIFF(dd,@StartDate,@EndDate)+1

     SELECT STR(Number*90+1,4)

          + ' -'

          + STR(CASE

                   ...

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

    February 5, 2007 at 7:13 am

    #687741

  • RE: Day Range Caluculations

    Set based solution... substitute a tally table for spt_Values if you have one...

    DECLARE @StartDate DATETIME

    DECLARE @EndDate DATETIME

        SET @StartDate = '01/01/2006'

        SET @EndDate = '10/02/2007'

      PRINT DATEDIFF(dd,@StartDate,@EndDate)+1 --Just...

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

    February 5, 2007 at 7:10 am

    #687740

  • RE: JOIN screwing things up.

    Nope... not the NULL thing.  My explanation is probably going to sound a little "dated" because I gave up the "GUI world" about 5 years ago when my boss (actually,...

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

    February 4, 2007 at 10:18 pm

    #687669

  • RE: Time Difference

    John,

    What is the data type of the column you are calling "TimeStamp"?

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

    February 4, 2007 at 6:24 pm

    #687663

  • RE: xp_cmdshell not working with FTP on server

    Where is the "E" drive... on the server or on your local drive?  If it's not on the server, you must use the UNC name back to the path where...

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

    February 4, 2007 at 6:18 pm

    #687662

  • RE: select for update vs. UPDLOCK

    Post your cursor and let's see if we can help you get rid of it because it has the biggest and worst impact both on performance and resources.

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

    February 4, 2007 at 6:08 pm

    #687661

  • RE: Reading txt file then creating new table

    I might MOVE the file to an "archive" directory, but I wouldn't delete it until I was sure the server had gone through a backup cycle.

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

    February 4, 2007 at 6:03 pm

    #687660

  • RE: SQL Server 2000 SP 4 issue with query

    Heh... well done... I'm thinking that if SP4 is so tough on cursors, then I like it a lot

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

    February 4, 2007 at 5:19 pm

    #687657

  • RE: JOIN screwing things up.

    FYI... the WHERE 1=1 thing is what a lot of GUI programmers do when writing embedded SQL with dynamic WHERE clauses...  they will always have a valid WHERE clause and 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)

    February 4, 2007 at 5:15 pm

    #687656

  • RE: Question about Execution plan and...hardware??

    Another couple o' things to check...

    1. Are the boxes running the same version/service pack level of Windows Server?
    2. Are the boxes running the same EDITION/service pack level of SQL Server (SQL Server Standard...

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

    February 4, 2007 at 5:09 pm

    #687655

  • RE: Finding values with cents...

    I agree with that!  The looping has got to interfere with the overall performance.

    Anyway, Michael... I have a question about your wonderful F_TABLE_NUMBER_RANGE  function... Since it's very fast (Surprisingly so! ...

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

    February 4, 2007 at 4:42 pm

    #687654

Viewing 15 posts - 56,986 through 57,000 (of 59,101 total)