SET dateformat mdy
GO
declare @start DATE = '01/01/2013'
declare @end DATE = '12/31/2013'

;with DateCte(staffno, zdate) 
AS
(
	SELECT 'A' + RIGHT( '000' + convert(varchar(2), @start, 101), 3) , @start
	UNION ALL
	SELECT 'A' + RIGHT( '000' + convert(varchar(2), zdate, 101), 3), DATEADD( dd, 1, zdate)
	FROM DateCte 
	WHERE CONVERT(VARCHAR(10), zdate, 101) <  @end
)
SELECT staffno, zdate FROM DateCte
OPTION (MAXRECURSION 0)

declare @start DATE 
SET @start = '20130101'
declare @end DATE 
SET @end = '20131231'

declare @staff table(staffNo char(4))
insert into @staff (staffno)
select 'A001' union all
select 'A002' union all
select 'A003' 

select staffNo,dateadd(day,sno-1,@start) as zdate from @staff cross join
(
	select top 365 row_number() over (order by name) as sno from sys.columns
) as t

declare @start DATE = '20130101'
declare @end DATE = '20131231'

;With Date_CTE(dt)
(
SELECT @Start
UNION ALL
SELECT DATEADD(dd,1,dt)
FROM Date_CTE
WHERE DATEADD(dd,1,dt)<=@End
)

select staffNo,dt 
from @staff 
cross join Date_CTE

OPTION (MAXRECURSION 0)