demo.sql

create function dbo.GetRows(@ID int)
returns @T table
(
  ID int,
  D datetime
) with schemabinding as
begin

  declare @N int;

  -- Time passes
  with C as
  (
    select 1 as N
    union all
    select C.N + 1
    from C
    where C.N < 50000
  )
  select @N = count(*)
  from C
  option (maxrecursion 0);

  insert into @T(ID, D) values(@ID, getdate());
  return;
end;

go

select R.ID, R.D
from (values(1),(1),(2),(2)) as T(ID)
  cross apply dbo.GetRows(T.ID) as R