CREATE FUNCTION [dbo].[Fn_FindDate](@intInterVal INT)
RETURNS @RESULT TABLE
(
 ReturnDt DATETIME
)
AS
BEGIN
 DECLARE
   @intAddDt  INT
  ,@dtNowDt  DATETIME

 SET @dtNowDt = GETDATE()
 SET @intAddDt = 0
 
 WHILE (@dtNowDt < DATEADD(D,@intInterVal-1,GETDATE()))
 BEGIN
  SET @dtNowDt = DATEADD(D, @intAddDt, GETDATE())
  SET @intAddDt = @intAddDt + 1
 
  INSERT @RESULT
  SELECT @dtNowDt
 END
 
 RETURN
END