1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| ;WITH cte_doc (AR_Ref, delaitemp) AS
(
SELECT
AR_Ref
,MAX((((DATEDIFF(day, DO_Date, DO_DateLivr)/7)*5)))
FROM F_DOCLIGNE
GROUP BY AR_Ref
)
UPDATE artf
SET
AF_DelaiAppro = doc.delaitemp
FROM [AUMATECH].[dbo].F_ARTFOURNISS AS artf
join cte_doc AS doc ON doc.AR_REF = artf.AR_REF
join F_ARTFOURNISS AS fourn ON fourn.AR_REF = artf.AR_REF
join F_ARTICLE AS art ON art.AR_Ref = doc.AR_Ref
join F_DOCLIGNE AS docl ON docl.AR_Ref = doc.AR_Ref
join F_COMPTET AS tiers ON tiers.CT_Num = artf.CT_Num
WHERE
docl.DO_Type = '12'
and tiers.CT_DelaiAppro = 0
and doc.delaitemp > 0 |
Partager