Rebol网格控制(Rebol grid control)

 你使用这样的查询，添加WHERE子句与你要检查函数返回数据的条件 
 
DECLARE @t TABLE 
(
   d DATE   
)
INSERT INTO @t
VALUES
('2016-06-15')
,('2016-05-11')
,('2016-04-15')
,('2016-03-15')
,('2016-02-16')
,('2016-01-14')

SELECT t.*,fn.*
FROM
    ( 
        SELECT *,
            LEAD(d) OVER (ORDER BY d ) as NextDate
        FROM @t 
    ) AS t
OUTER APPLY dbo.MyCompare(d, NextDate ) as fn
--WHERE fn.columnname IS NOT NULL
 
 LEAD分析功能适用于SQL Server 2012或更高版本。 如果您使用的是早期版本，请尝试以 
 
;WITH CTE AS 
(
    SELECT *, ROW_NUMBER() OVER( ORDER BY d ) AS RowNo 
    FROM @t
)

SELECT c.d, c1.d AS NextDate, fn.*
FROM CTE c
LEFT JOIN CTE c1 ON c1.RowNo = c.RowNo + 1
OUTER APPLY dbo.MyCompare(c.d, c1.d ) as fn
--WHERE fn.columnname IS NOT NULL

you use query like this, add WHERE clause with condition you want to check on the function return data
 
DECLARE @t TABLE 
(
   d DATE   
)
INSERT INTO @t
VALUES
('2016-06-15')
,('2016-05-11')
,('2016-04-15')
,('2016-03-15')
,('2016-02-16')
,('2016-01-14')

SELECT t.*,fn.*
FROM
    ( 
        SELECT *,
            LEAD(d) OVER (ORDER BY d ) as NextDate
        FROM @t 
    ) AS t
OUTER APPLY dbo.MyCompare(d, NextDate ) as fn
--WHERE fn.columnname IS NOT NULL
 
LEAD analytical function works with SQL Server 2012 or later. If you are using earlier versions try below.
 
;WITH CTE AS 
(
    SELECT *, ROW_NUMBER() OVER( ORDER BY d ) AS RowNo 
    FROM @t
)

SELECT c.d, c1.d AS NextDate, fn.*
FROM CTE c
LEFT JOIN CTE c1 ON c1.RowNo = c.RowNo + 1
OUTER APPLY dbo.MyCompare(c.d, c1.d ) as fn
--WHERE fn.columnname IS NOT NULL