title: how to call a stored procedure in where clause of SQL
body: <p>I have a T-SQL script, requirment is I need to call a stored procedure in where clause. This stored procedure accept a parameter and returns a bit result. Kindly guide me how to do it. </p>
  
  <p>Thanks</p>
  
  <p>Edit:
  I cant modify this sp and make it a function. please</p>