1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| ALTER procedure [dbo].[PS_GEN_ADD_BOITIER_ZONE_BZO]
with recompile
as
declare @DT_CREATE datetime
set @DT_CREATE = GETUTCDATE()
insert into dbo.T_BOITIER
(BZO_ID, NUM_ORDER, DT_CREATE, IS_DELETE,
BOI_ID, YBR_ID, BZO_LIB, BZO_DATA, BZO_IS_ALERT, BZO_IS_PAYS)
select t.BZO_ID, isnull(dm.NUM_ORDER, 0) + 1, @DT_CREATE, 0,
t.BOI_ID, t.YBR_ID, t.BZO_LIB, t.BZO_DATA, t.BZO_IS_ALERT, t.BZO_IS_PAYS
from #BOITIER t
left join (
select BZO_ID, max(NUM_ORDER) as NUM_ORDER
from dbo.T_BOITIER_ZONE_BZO_DETAIL
group by (BZO_ID)
) dm
on dm.BZO_ID = t.BZO_ID |
Partager