create table myTable (sales_person varchar(10), model varchar(10), date_sold datetime)

insert into myTable (sales_person, model, date_sold)
values ('David','A', cast('2008-01-01' as datetime))

insert into myTable (sales_person, model, date_sold)
values ('David','A', cast('2008-01-02' as datetime))

insert into myTable (sales_person, model, date_sold)
values ('David','A', cast('2008-01-03' as datetime))

insert into myTable (sales_person, model, date_sold)
values ('Fred','A', cast('2008-01-01' as datetime))

insert into myTable (sales_person, model, date_sold)
values ('Fred','A', cast('2008-01-04' as datetime))

insert into myTable (sales_person, model, date_sold)
values ('Fred','A', cast('2008-01-06' as datetime))

select * from myTable

drop table myTable