CREATE TABLE _Today ( _getdate AS getdate() , _dummy bit NOT NULL) INSERT _Today VALUES (0)on UDF
DECLARE @Today DATETIME SELECT @Today=_getdate FROM _Todaybut for function like RETURN TABLE, i need SQL eval GETDATE() only one time,
SELECT ...complexmultijoin WHERE (SELECT @Today=_getdate FROM _Today)>myDateThen, why UDF not support GETDATE(), if i can workaroud it easy ???