17,086
社区成员
发帖
与我相关
我的任务
分享
insert into organization
select top 1 (select max(id)+1 from organization)
,(select isnull(max(org_no),'') from organization where id=@pid)+right('000'+convert(varchar,max(
convert(int,
right(org_no,
len(org_no)-len(select max(org_no) from organization where id=@pid)
)
)
)+1
),
len(select max(org_no) from organization where id=@pid)+3
)
,@orgname
,@pid
from organization
where parent_id=@pid