title: Is it possible to execute a stored procedure over a set without using a cursor?
body: <p>I would like to execute a stored procedure over each row in a set without using a cursor with something like this: 
  <br/><br/>
  <code>SELECT EXEC dbo.Sproc @Param1 = Table1.id<br/>
  FROM Table1
  </code>
  <br/><br/>
  I am using T-SQL in SQL Server 2005. I think this might be possible using a function, but I'd like to use a stored procedure if possible (company standards)</p>