BEGIN
 declare 
 @dataid int,
 @pat_id int,
 @mot_id int,
 @m_id int,
 @tip_ds int,
 @vid_diagnosa int,
 @mkb int,
 @n int,
 @i int,
 @n_line int

set @pat_id=(select patients_id from INSERTED)
set @mot_id=(select motconsu_id from INSERTED)
set @m_id=(select max(d.motconsu_id) from DATA_DIAGNOSIS d
           join inserted as i
           on d.patients_id=i.patients_id
           join motconsu as m
           on m.patients_id=i.patients_id          
           where m.models_id=326)
set @n=(select count(*) from data_diagnosis where motconsu_id=@m_id)

if EXISTS
(select * from motconsu m
join inserted as i
on m.patients_id=i.patients_id
where i.models_id=326)
AND
exists (select * from data_diagnosis d
join inserted as i
on d.patients_id=i.patients_id)
BEGIN
select @i=1 
while @i<@n
  BEGIN  
  declare diagnoz cursor for
  select patients_id, tip_diagnoza, n_line
  from data_diagnosis
  where motconsu_id=@m_id
  open diagnoz
  fetch next from diagnoz into @pat_id, @tip_ds, @n_line
  while @@fetch_status=0
     BEGIN
     set @n_line=1
     EXEC up_get_id 'DATA_DIAGNOSIS', 1, @dataid OUTPUT     
     insert into data_diagnosis (patients_id, motconsu_id, data22_id, n_line, 
     tip_diagnoza) values (@pat_id, @mot_id, @dataid, @n_line, @tip_ds)
     set @n_line=@n_line+1
     fetch next from diagnoz into @pat_id, @tip_ds, @n_line  
     END
     
  close diagnoz
  deallocate diagnoz   
  END
  
 END
END

fetch next from diagnoz into @pat_id, @tip_ds, @n_line
  while @@fetch_status=0
     BEGIN
     set @n_line=1
     EXEC up_get_id 'DATA_DIAGNOSIS', 1, @dataid OUTPUT     
     insert into data_diagnosis (patients_id, motconsu_id, data22_id, n_line, 
     tip_diagnoza) values (@pat_id, @mot_id, @dataid, @n_line, @tip_ds)
     set @n_line=@n_line+1
     fetch next from diagnoz into @pat_id, @tip_ds, @n_line  
     END

fetch next from diagnoz into @pat_id, @tip_ds, @n_line
   set @n_line=1
  while @@fetch_status=0
     BEGIN
     EXEC up_get_id 'DATA_DIAGNOSIS', 1, @dataid OUTPUT     
     insert into data_diagnosis (patients_id, motconsu_id, data22_id, n_line, 
     tip_diagnoza) values (@pat_id, @mot_id, @dataid, @n_line, @tip_ds)
     set @n_line=@n_line+1
     fetch next from diagnoz into @pat_id, @tip_ds, @n_line  
     END

BEGIN
 declare 
 @dataid int,
 @pat_id int,
 @mot_id int,
 @m_id int,
 @tip_ds int,
 @vid_diagnosa int,
 @mkb int,
 @n int,
 @i int,
 @n_line int

set @m_id=(select max(d.motconsu_id) from DATA_DIAGNOSIS d
           join inserted as i
           on d.patients_id=i.patients_id
           join motconsu as m
           on m.patients_id=i.patients_id          
           where m.models_id=326)
set @n=(select count(*) from data_diagnosis where motconsu_id=@m_id)

if EXISTS
(select * from motconsu m
join inserted as i
on m.patients_id=i.patients_id
where i.models_id=326)
AND
exists (select * from data_diagnosis d
join inserted as i
on d.patients_id=i.patients_id)
BEGIN
select @i=1 
while @i<@n
  BEGIN  
  declare diagnoz cursor for
  select ROW_NUMBER() over (order by n_line desc) As Row, tip_diagnoza
  from data_diagnosis
  where motconsu_id=@m_id
  open diagnoz
  fetch next from diagnoz into @n_line, @tip_ds
  while @@fetch_status=0
     BEGIN
   
     set @pat_id=(select patients_id from INSERTED)
     set @mot_id=(select motconsu_id from INSERTED)   
     EXEC up_get_id 'DATA_DIAGNOSIS', 1, @dataid OUTPUT     
     insert into data_diagnosis (patients_id, motconsu_id, data22_id, n_line, 
     tip_diagnoza) values (@pat_id, @mot_id, @dataid, @n_line, @tip_ds)
    
     fetch next from diagnoz into @n_line, @tip_ds  
     END
     
  close diagnoz
  deallocate diagnoz   
  END
  
 END
END