Bug fix: Revise stored procedure to also set IsIgnored bit for projects with NULL expenses.

ucdavis / AD419DataHelper

Data Loader and review website for the AD-419 Report

MIT License

1 stars 0 forks source link

Bug fix: Revise stored procedure to also set IsIgnored bit for projects with NULL expenses. #189

Closed taylorkj closed 7 years ago

taylorkj commented 7 years ago

Probably best to update the sproc to include an ISNULL(sum(Expenses),0) statement to the existing sum statement so that the 204 projects with zero expenses will be included in the list.

taylorkj commented 7 years ago

Done as part of PR #190 and #191