获取指定日期范围的工作日日期

declare @begindate date,@enddate date
declare @t table(EFFDT date)
select @begindate= CONVERT(DATE,'20150401')
select @enddate=CONVERT(DATE,'20150601')
while (@begindate<>@enddate)
begin
	if(DATEPART(DW,@begindate) between 2 and 6)
	begin
		insert into @t select @begindate
	end
	select @begindate= DATEADD(DAY,1,@begindate)
end

select * from @t