select * from haoyoutable where fid in(select fids from userinfo where userid=100)

declare @tb table (id int, cname nvarchar(20), ctype nvarchar(20), total int)
insert into @tb
select 1,   'a',   'aa', 0   
union all select 1   ,'a1',  'aa',     2 
union all select 1   ,'a2',  'aa',     0 
union all select 1   ,'b',   'bb',     0 
union all select 1   ,'b1',  'bb',     1 
union all select 1   ,'b2',  'bb',     2 
union all select 2   ,'a',  'aa',     0 
union all select 2   ,'a1',  'aa',     6 
union all select 2   ,'a2',  'aa',     4 
union all select 2   ,'b',   'bb',     0 
union all select 2   ,'b1',  'bb',     5 
union all select 2   ,'b2',  'bb',     4 
union all select 3   ,'a',   'aa',     0 
union all select 3   ,'a1',  'aa',     3 
union all select 3   ,'a2',  'aa',     0 
union all select 3   ,'b',   'bb',     0 
union all select 3   ,'b1',  'bb',     2 
union all select 3   ,'b2',  'bb',     4

select * from @tb where id in (1,2)
/*
id          cname                ctype                total
----------- -------------------- -------------------- -----------
1           a                    aa                   0
1           a1                   aa                   2
1           a2                   aa                   0
1           b                    bb                   0
1           b1                   bb                   1
1           b2                   bb                   2
2           a                    aa                   0
2           a1                   aa                   6
2           a2                   aa                   4
2           b                    bb                   0
2           b1                   bb                   5
2           b2                   bb                   4
*/

create proc wsp
@userid int
as
    select a.* from 用户表 a,用户表 b 
    where b.userid=@userid and charindex(','+ltrim(a.userid)+',',','+b.fids+',')>0
go


--调用：
exec wsp 100

select * from Usertable where [UserId] in  
(select FIds from Usertable where UserId= 132) 

create procedure friends
@uid int
as 
select * from haoyoutable where userid in (select fids from haoyoutable where uid=@uid)

CREATE PROCEDURE  procedureName
(
    @userid int
)
AS
BEGIN

    declare @sql varchar(max)    --sql查询语句
    declare @ids varchar(max)    --用户id集合

    select @ids=fids from tableName where userid=@userid

    set @sql='select * from tableName where userid in (' + @ids + ')';
    exec(@sql)
end

declare @table table (userid int, username varchar(20),fids varchar(200))
insert into @table
select            1000   ,'a0',   '1001'   
union  select 1001   ,'a1',  '1002'
union  select 1002   ,'a2',  '1000,1001,1003'
union  select 1003   ,'a3',   '1002,1000' 
--将条件下的fids存储在一个临时变量中
declare @temp varchar(200)
set @temp=(select fids
from
@table
where 
userid=1002
)
--定义一个临时表
declare @tb table(userid int)
--将临时变量拆借，放入临时表中
while charindex(',',@temp)>0
BEGIN
insert into @tb
    select 
    CAST ( substring(@temp,1,charindex(',',@temp)-1) AS int ) 
    set @temp=substring(@temp,charindex(',',@temp)+1,len(@temp))

END
insert into @tb
    select @temp
--得到最终信息
select 
    *
from
    @table
where
    userid 
in
(
    select userid
    from
    @tb
)