SQL function

SQL code:

create function f_getOrgaChildIds_str_byRootId(@rootid varchar(5000))
returns varchar(5000)
AS
BEGIN
declare @childids varchar(5000)
declare @orgaid varchar(5000)

declare @table1 table(organizationid int)
declare @sql varchar(6000)
set @sql = 'select organizationid from organization where parentid in (' + @rootid+')'
insert into @table1 exec(@sql)

declare my_cursor cursor for
select organizationid from @table1

Open my_cursor
fetch my_cursor into @orgaid
select @childids=''
while @@fetch_status=0
begin
select @childids=@childids+@orgaid+','
fetch my_cursor into @orgaid
end
close my_cursor
deallocate my_cursor
--drop table #table1

if (@childids!='')
begin
select @childids= substring(@childids,1,len(@childids)-1)
declare @str varchar(5000)
select @str=dbo.f_getOrgaChildIds_str_byRootId(@childids)
set @childids=@childids+','+@str
end

return @childids
END



¼ì²éÓ﷨ʱͨ¹ýÁË£¬Ö´ÐÐÊDZ¨´í£º
SQL code:
ÏûÏ¢ 443£¬¼¶±ð 16£¬×´Ì¬ 14£¬¹ý³Ì f_getOrgaChildIds_str_byRootId£¬µÚ 11 ÐÐ
ÔÚº¯ÊýÄÚµÄ 'INSERT EXEC' ÖжԴø¸±×÷ÓõĻòÒÀÀµÓÚʱ¼äµÄÔËËã·ûµÄʹÓÃÎÞЧ¡£


²»ÄÜ»»´æ´¢¹ý³Ì£¬ÒòΪҪµÝ¹é£»º¯ÊýÀï²»ÄÜÓÃÁÙʱ±í¹þ
Õâ´íÎó¸ÃÔõô¸Ä¡¢Ôõô±äͨ£¿

---

²»ÄÜ»»´æ´¢¹ý³Ì£¬Òò