Stored procedure not displaying data when null is passed into input parameter
Well, I figured out the problem by myself. I removed _subject_name IS NULL in both the first and the second IF condition and it worked as expected.