title: Array like functionality in SQL Server 2008
body: <p>I want to read <code>EmpID</code> in <code>EMP</code> Table based on some condition. For every <code>EmpID</code> I need to do some operation in another table. How can I read single value of <code>EmpID</code> at a time.</p>
  
  <p>Thanks in advance</p>