create table #rykey(FirstName varchar(50), LastName varchar(50),
TimeType Varchar(50), days float)
insert into #rykey
select 'John', 'Smith', 'Annual', 9.75 union
select 'John', 'Smith', 'Annual', 3.25 union
select 'John', 'Smith', 'Holiday', 6.00 union
select 'John', 'Smith', 'Holiday', 2.00 union
select 'John', 'Smith', 'OT', 5.75
--this part is for you
select FirstName, LastName, TimeType, sum(days)
from #rykey
group by FirstName, LastName, TimeType
--this part is for you
drop table #rykey
Thanks...this will work but I failed to mention that there are several hundred employees and about 6000 lines of data. How do I populate all of the data into the table without manually inserting each record?