declare @dates table (TransDate smalldatetime)
insert into @dates
select '2010-01-01' union all
select '2010-01-02' union all
select '2010-01-03' union all
select '2010-01-04' union all
select '2010-01-05' union all
select '2010-01-06' union all
select '2010-01-07' union all
select '2010-01-08' union all
select '2010-01-09' union all
select '2010-01-10' union all
select '2010-01-11' union all
select '2010-01-12' union all
select '2010-01-13' union all
select '2010-01-14' union all
select '2010-01-15' union all
select '2010-01-16' union all
select '2010-01-17' union all
select '2010-01-18' union all
select '2010-01-19' union all
select '2010-01-20' union all
select '2010-01-21' union all
select '2010-01-22' union all
select '2010-01-23' union all
select '2010-01-24' union all
select '2010-01-25' union all
select '2010-01-26' union all
select '2010-01-27' union all
select '2010-01-28' union all
select '2010-01-29' union all
select '2010-01-30' union all
select '2010-01-31'

declare @emp table (EmpID int, EmpName varchar(20))
insert into @emp 
select 1, 'Jim' union all
select 2, 'John' union all
select 3, 'Mike' 

declare @sales table (EmpID int, TransDate smalldatetime, Sales decimal (8,2))
insert into @sales
select 1, '2010-01-10', 100 union all
select 1, '2010-01-14', 200 union all
select 1, '2010-01-15', 300 union all
select 1, '2010-01-22', 400 union all
select 1, '2010-01-28', 500 union all
select 2, '2010-01-01', 1000 union all
select 2, '2010-01-24', 2000 union all
select 3, '2010-01-31', 3000


-- not sure if you want all days and employees and only show the sales they had on 
-- those days
select d.TransDate, s.Sales, E.EmpID
from @dates d
	cross apply @emp e
	left outer join @sales s
		on d.TransDate = s.TransDate
		AND e.empID = s.EmpID		
		
-- or just the dates they worked which is just a straight select
select TransDate, Sales, EmpID
from @sales