-- select * from [dbo].fnDateTable
CREATE FUNCTION [dbo].[fnDateTable] (@fr_dt DATETIME, @to_dt DATETIME)
RETURNS @TmpBaseDt TABLE(
std_dt DATETIME
)
AS
BEGIN
Declare
@cnt Int ,
@seq Int ,
@dt Datetime
Set @cnt = 0
Set @seq = 0
Set @cnt = DateDiff(Day, @fr_dt, @to_dt)
While(@cnt >= @seq)
Begin
SET @dt = DateAdd(Day, @seq, @fr_dt)
INSERT @TmpBaseDt
Select @dt
Set @seq = @Seq + 1
End
RETURN
END