Home Forums SQL Server 7,2000 T-SQL SQL UDF to return hours RE: SQL UDF to return hours

  • November 15, 2004 at 12:08 am

    #530072

    Hi Dave!

    I am a newbie when it comes to SQL, sorry for inconvienience, your answer worked perfectly, but  I meant to say minutes

    With your above answer, can you change that to return MINUTES instead of hours and exclude holidays that are in TableA .  Lets say TableA has

    HolidayDate

    2004-08-09 00:00:00.000

    2004-09-24 00:00:00.000

    2004-12-16 00:00:00.000

    2004-12-26 00:00:00.000

    2004-12-25 00:00:00.000