title: data not Showing when execute the stored procedure in Sql
body: <p>I write this code in my stored procedure:<br></p>
  <pre class="lang-sql prettyprint-override"><code>ALTER PROC sp_ShowComplaintStatus (@pid bigint,
                                     @compid int)
  AS
  BEGIN
      SET NOCOUNT ON;
      SELECT PId,
             C.Compld,
             CC.ComplCategory,
             CSC.ComplSubCategName,
             S.Status
      FROM TN_Complaint C
           INNER JOIN TN_ComplStatus CS ON C.Compld = CS.CompId
           INNER JOIN Z_Status S ON CS.StatusId = S.StatusId
           INNER JOIN Z_ComplCategory CC ON C.CompCategId = CC.ComplCategoryId
           INNER JOIN Z_ComplSubCategory CSC ON C.ComplSubCategoryId = CSC.ComplSubCategoryId
      WHERE PId = @pid
        AND C.Compld = @compid;
  END;
  
  
  sp_ShowComplaintStatus 10001, 1000;
  </code></pre>
  <p>But when I execute my stored procedure, it doesn't show any records. It only show column name.</p>