SQL query question

Hi,

Try this one :

select [EmployeeId],max(case when [Status]=1 then 1 else 0 end) from [dbo].[EmployeeJobs] group by [EmployeeId]

JN.

---

Jean-Nicolas BERGER

http://blog.sqlserver.fr