Forum Replies Created

Viewing 15 posts - 40,516 through 40,530 (of 59,098 total)

  • RE: Incrementing Values

    Heh... like Jackie Chan's Uncle says in the cartoon, "And one mo ting!"

    There is a way to totally obfuscate the cross-joins if you ever need to do such a thing......

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

    December 24, 2009 at 3:26 pm

    #1096416

  • RE: Incrementing Values

    Dugi, thanks for the kudo but it's not mine alone... take a look at the "credits" on that thing... lots of folks had some great ideas that improved the great...

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

    December 24, 2009 at 3:14 pm

    #1096413

  • RE: Incrementing Values

    Heh... and for those who are mildly curious as to what Rev 03 may have been... I ran into a human stone wall who would not allow code to be...

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

    December 24, 2009 at 3:03 pm

    #1096405

  • RE: Incrementing Values

    Nabha is spot on and, if you check out the link he posted, you'll find the "Tally" table is a pretty nice replacement for the spt_Values table and has a...

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

    December 24, 2009 at 2:46 pm

    #1096401

  • RE: High reads when Inserting single value

    TheSQLGuru (12/24/2009)

    It is almost certainly the foreign keys.

    run an insert from SSMS with set statistics on and show actual execution plan. My best guess is that one...

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

    December 24, 2009 at 11:13 am

    #1096371

  • RE: High reads when Inserting single value

    freeman.e.l (12/23/2009)

    this is probably caused by a large number of indexes.

    Absolutely spot on, Freeman.

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

    December 24, 2009 at 11:02 am

    #1096367

  • RE: Need query

    Ah... one other thing... just to prove that it works across multiple month boundaries and even year boundaries, here's a change in the data. My recommendation would be 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)

    December 24, 2009 at 10:46 am

    #1096360

  • RE: Need query

    Prakash-485822 (12/23/2009)

    Dear All ,

    Please find below the data

    MonthStart MonthEnd MonthTotalDaysAmount

    Mar3/9/09 0:003/13/09 0:004 71

    Mar3/23/09 0:004/5/09 0:0014 ...

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

    December 24, 2009 at 10:14 am

    #1096347

  • RE: Need query

    freeman.e.l (12/24/2009)

    The question was not clear by any means. Additionally, the second example does not have a logical relationship that holds true for Start Date, End Date and TotalDays.

    I thought...

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

    December 24, 2009 at 9:58 am

    #1096343

  • RE: Need query

    MonthStart MonthEnd MonthTotalDaysAmount

    Mar3/9/09 0:003/13/09 0:004 71

    Mar3/23/09 0:004/5/09 0:0014 ...

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

    December 24, 2009 at 2:08 am

    #1096262

  • RE: Need query

    arun.sas (12/24/2009)

    Hi Jeff,

    But still am using the @@IDENTITY, yet no issue raised, ok will check your advice.

    Ah... sorry, my bad.l I just started reading your code more in depth...

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

    December 24, 2009 at 2:03 am

    #1096261

  • RE: Need query

    freeman.e.l (12/24/2009)

    declare @start_date datetime

    declare @end_date datetime

    declare @diff int

    set @start_date = '3/9/2009'

    set @end_date = '3/13/2009'

    set @diff = datediff(dd,@start_date,@end_date)

    create table #Results ([Month Start] datetime, [Month End] datetime, [Total Days] int, [Amount] money)

    insert...

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

    December 24, 2009 at 1:54 am

    #1096257

  • RE: Need query

    I haven't check the rest of your good post, but don't ever use @@IDENTITY... if a trigger is ever place on the table in question, @@IDENTITY will return incorrect answers....

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

    December 24, 2009 at 1:46 am

    #1096254

  • RE: CLR Table-Valued Function Example with Full Streaming (STVF)

    Thanks for the feedback, Solomon. Glad to see folks using it for smart stuff.

    As a side bar, Matt Miller and I had some friendly races a couple/three years ago...

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

    December 24, 2009 at 1:00 am

    #1096241

  • RE: Create a new column with criteria

    Biz (12/23/2009)

    Hi Jeff,

    Thats working... Was thinking to sort it dynamically and then do this.

    But this is really easy..

    Thanks

    Merry Xmas..

    Thanks for the feedback. "Easy" is good. 😉 Shifting...

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

    December 23, 2009 at 5:57 pm

    #1096192

Viewing 15 posts - 40,516 through 40,530 (of 59,098 total)