Closed tfremming1 closed 4 years ago
The Stored PROC is already written needs a 2 line adjustment
https://github.com/IncidentManagementSystems/IMS.API/blob/development/src/Ims.Api.Db/Programmabillity/Stored%20Procedures/Agency_StateProgramHoursSummary.sql
Under Select drop the
AgentId StateProgramId
from the report
Otherwise when I run it for a dept e.g. Agency 3 in PROD. I get the right results:
The Stored PROC is already written needs a 2 line adjustment
https://github.com/IncidentManagementSystems/IMS.API/blob/development/src/Ims.Api.Db/Programmabillity/Stored%20Procedures/Agency_StateProgramHoursSummary.sql
Under Select drop the
AgentId StateProgramId
from the report
Otherwise when I run it for a dept e.g. Agency 3 in PROD. I get the right results: