title: cursor sql problems
body: <p>why wont it display more than one result? Also i'm getting this error message"Conversion failed when converting the varchar value 'fetch_status' to data type int" whats wrong with my code?</p>
  
  <pre><code>  Declare [plzwork] cursor
  for 
  Select * from [itsthegoodtable]
  
  Where [Methodofpayment] = 'pd'
  
  ---open cursor
  
  Open [plzwork]
  
  Fetch next from [plzwork]
  
  while 'fetch_status' = 0
  
  fetch next from [plzwork]
  
  close [plzwork]
  
  deallocate [plzwork]
  </code></pre>