SQL beginner here. In my query one of the columns is interesting in that it exists for some records but not for others (as opposed to existing with a null value).
In the attached file, the column in question is PROVIDERS_GOALS_DATA.NOVEMBER_HOURS.
Specifically, I’m reporting on staff monthly productivity. Our agency has 10 programs, but a staff’s productivity hours are only charged off to one or two programs. The tricky part is that sometimes staff will charge off hours to a different program, but there is no record in the database linking the staff to that program (although I still need to report on those hours).
Is there a way to set up the query to return 0 for PROVIDERS_GOALS_DATA.NOVEMBER_HOURS whenever this occurs?
Thanks very much in advance, and please let me know if more info is needed.
SQL.txt (2.14 KB)