create procedure a_user_dept_edit ( @uid int, @deptidStr varchar(300) ) as

declare @index int, @id int

if @deptidStr is null
   begin
     select @deptidStr=''
   end

create table #temp ( did int )

if @deptidStr<>''
   begin
     if left(@deptidStr,1)=','
        begin
          select @deptidStr=substring(@deptidStr,2,len(@deptidStr) - 1)
        end
     if right(@deptidStr,1)<>','
        begin
          select @deptidStr=@deptidStr + ','
        end
     select @index=charindex(',', @deptidStr)
     while @index>1
       begin
         select @id=substring(@deptidStr, 1, @index - 1)
         if @id<>0
            begin
              insert into #temp (did) values (@id)
              if not exists (select udid from T_user_dept where uid=@uid and deptid=@id)
                 begin
                  insert into T_user_dept (uid, deptid) values (@uid, @id)
                 end
            end
         select @deptidStr=substring(@deptidStr, @index + 1, len(@deptidStr) - @index)
         select @index=charindex(',', @deptidStr)
       end
   end

delete from T_user_dept where uid=@uid and deptid not in (select did from #temp)