CREATE FUNCTION [dbo].[GetLatest10Dates1](
@mydate datetime
)
RETURNS
@tbl table (mydate datetime)
AS
BEGIN
declare @i int =0
while(@i < 15)
begin
insert into @tbl(mydate)
select @mydate+@i
set @i = @i+1
end
RETURN
END
//////////////////////////////////////////////////////////////
you can see the result like
Declare @dat date
set @dat='2013-01-01'
Declare @tbl table (mydate datetime,rn int)
insert into @tbl(mydate,rn)
(Select *, row_number() over (order by mydate ) as m From dbo.GetLatest10Dates1(cast(@dat as date)))
select * from @tbl