I need some help.
I am using SQL 2005, and I have a calendar created, attach is an example of how my calendar looks.
What I would like to go is create a script that would update the table BTItem that has a field name 'DATE'
which would have a numeric value e.g. 1 = Sunday, 2 = Monday....etc...so the script would add 1 to the date field.
But here is the catch, I only want the script to run on working days.
Weekends and holidays I DO NOT want it to update the table BTItem.
What is the SQL code for this ???
I am at a lost.