date difference

create function dbo.func_SelisihTanggal(
    @Date1 date,
    @Date2 date
    )returns @result table
    (
        [Date] date
    )
as
begin
    while @Date1 <= @Date2
    begin
        insert into @result values(@Date1)
        set @Date1 = dateadd(day, 1, @Date1)
    end

    return;
end
go