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...