Home Forums SQL Server 2012 SQL Server 2012 - T-SQL create a function to update workingdays column RE: create a function to update workingdays column

  • June 19, 2013 at 10:43 am

    #1625569

    gissah (6/19/2013)

    Thank you sir, All I want to do is just populate the [BusinessDay] column on my table sequentially(1234...) if a day qualify as a business day or workday(MTWTF). Thanks

    What is day 1 - Jan 1st? Do you restart numbering every year? Are you only concerned with Monday-Friday - what about statutory holidays?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.