So I have a report we use in SSMS, that pulls data from a table called Fact_JobLaborCosting_Weekly. The SSMS report still works fine for most of it. However, we found that some of our newer jobs we are not able to select a StartDate in the SSMS report.
So I queried the Fact_JobLaborCosting_Weekly table and noticed the most recent data is from 07-2022, so for some reason it stopped inserting data into the table after 07-2022. So I am trying to find the stored procedure that populates that table to see if there is a hard coded date range or something that needs to be edited.
Any advise or suggestions? Thank you.
Tried searching in sys.sql_modules and other random stored procedures with no luck.