Following could be reason(s):
1) Multiple Exit Point in the stored procedure. We may have RETURN statement before stored procedure forming final output
2) All data is getting filtered. It may be due to wrong WHERE condition or JOIN condition.
3) Error Occurred and execution went to CATCH block
4) Data COLLATION issue
5) Data mismatch issue
6) Access issue with some table(s) or schema
No comments:
Post a Comment