I have a table that stores all of our Server Patching information. We track the Server Name, Patch_Day (Mon, Tues, etc..) Patch_Start_Time, Patch_End_Time, etc..
We use a dtsx job to go out and schedule all of our patching jobs through altiris, but we have a little bit of manual intervention in this process, since I don't know how to Correspond the Day listed in Patch_Day with a Date. I'd like to add a column for Patch_Date or even better use the date that shows in the Patch_Start_Time field...
So for instance if Patch_Day = Friday then Patch_Date = (2nd Tuesday of month + 3)
Is there a way to do this, and have the database roll over each month so that it's always using the current month's (2nd Tuesday + 3)?:hehe:
Heather aka sql-retard :D