Jeff,

Yes, I would consider using a cursor over the set based approach depending on the circumstances such as the size of the dataset and use for which I need the...

This will work with multiple employees and contract types.

Chris

---

declare @firstName varchar(50),

@surName varchar(50),

@contractType varchar(500)

create table #results (firstName varchar(50),

surname varchar(50),

contractType varchar(500))

declare curRecs cursor local for

select distinct firstname, surname from #myTable

open...