set nocount on;
/*
drop table table1;
create table table1
(
  id int not null primary key,
  name varchar(300) not null
);
with X (n) as
(
  select 1
  union all
  select n+1 from x where n <= 99999
)
insert into table1(ID, NAME)
select n, cast(n as varchar(300))
from X
option (maxrecursion 0);
create index IX_S1 on table1 (name, id);
--*/

select top  1  Q.*
from table1 Q
  join table1 W on Q.ID = W.ID
order by Q.name, Q.id;

create function f_qwe()
returns table
as
return (select id from table1)
go

create function f_asd()
returns @t table (id int not null)
as
begin
  insert into @t (id) select id from table1;
  return;
end
go

select T.id
from table1 T
  left join f_qwe() P on T.id = P.id;

select T.id
from table1 T
  left join f_asd() P on T.id = P.id;

create or alter procedure p_qwe
returns (id integer)
as
begin
  for select id from table1 into :id do
    suspend;
end

select T.*
from table1 T
  left join p_qwe P on T.id = P.id

create function f_qqq(@n int)
returns table
as
  return (select id = @n)
go