I recently made some changes to a sproc that wasn't running well to a point it runs great now! It was doing magic for maybe 2 weeks, but suddenly nothing comes back now? It does show in the log file that it processed, but nothing is coming back?
The change was simple. Just switched the indexes on temp tables after data inserted vs. before, which it was doing.
Again, it worked great for 2 weeks, but now nothing returns.
I was talking to the developer and suggested to redeploy the RDL. Not sure what else to try?