title: i want to put if else statement in store procedure but not find any solution
body: <p>i want to put these conditions in my stored procedure</p>
  
  <pre><code>if ((select PriSubmissionStatusId from Claim where ClaimId = 375 )!= 106  ) Print 'Primary'
  else if((select SecSubmissionStatusId from Claim where ClaimId = 375 )= 0)print 'Primary'
  else if((select SecSubmissionStatusId from Claim where ClaimId = 375 )!= 106)print 'Secoundary'
  else if((select OthSubmissionStatusId from Claim where ClaimId = 375 )= 0)print 'Secoundry'
  else if((select OthSubmissionStatusId from Claim where ClaimId = 375 )!= 106)print 'Other'
  else print 'Primary'
  </code></pre>
  
  <p>as column name build up, their is also other column in stored procedure which come from different table. any idea?</p>