alter function [dbo].ReturnWeek() returns @testtable table (week int)

as

begin

declare @test-2 int

declare @i int

select @test-2= datediff(wk,'2009-03-01',getdate()+1)

set @i=1

while(@i<=@test)

begin

insert into @testtable values (@i)

set @i=@i+1

end

return

end

this is what i have done so far