I am trying to do up a resource calendar availability roster using SQL.
I can extract where the resource is on several projects, but they are putting their recreational days off onto their calendar. There is one calendar per resource, and I am unable to read these values in SQL as the calendar is in a different format with numberical values that can't be read.
Does anyone have any suggestions as to other options?
We have many casual resources that are on many projects, the main issue we have is that when allocating resources to a project there is no way to tell who is available or not.
Or, are the resources in the Add Resource form 1. only active ones show, 2. only ones that don't have recreational days off, 3. only ones that are not on other projects?
HEEEEEEEEEEEEEEEEEELP