TimeZone Function Causing Blcking

  • Does not seem to be. I have included the def in the attachement.

    Thanks.

  • r.pe (6/4/2012)


    Does not seem to be. I have included the def in the attachement.

    Thanks.

    Even that function has a function call, dbo.fn_NTDayOfWeek.

  • r.pe (6/4/2012)


    Does not seem to be. I have included the def in the attachement.

    Thanks.

    Hehehe... More functions in this one too. I would not be happy the development company that wrote these :hehe:

    Jared
    CE - Microsoft

  • Thanks Lynn and Jared.

    What gets me is that the function definitions are virtually the same in 3.0 and the 4.0 system. The nested calls are the same. The number of calls did change as the datetime columns increased.

    Anyway, thanks for your input.

    As for doing my homework, sure thing Jared (know it all;-)).

  • Lynn Pettis (6/4/2012)


    r.pe (6/4/2012)


    Does not seem to be. I have included the def in the attachement.

    Thanks.

    Even that function has a function call, dbo.fn_NTDayOfWeek.

    Okay, missed this one: dbo.fn_FirstDayOfMonth.

  • r.pe (6/4/2012)


    Thanks Lynn and Jared.

    What gets me is that the function definitions are virtually the same in 3.0 and the 4.0 system. The nested calls are the same. The number of calls did change as the datetime columns increased.

    Anyway, thanks for your input.

    As for doing my homework, sure thing Jared (know it all;-)).

    Yes, but adding just 1 more column that calls this function then adds several more function calls to these other functions within the 1st one. So really, 1 column is adding at least 3 function calls that I can see (probably more).

    Jared
    CE - Microsoft

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply