CREATE PROC dbo.SP_KONTEYNER_DURUM_GUNCELLE
(@ref INT)
AS
BEGIN
DECLARE @SAY INT
SET @SAY = ISNULL((SELECT COUNT(*) FROM [IHR].[dbo].[SIPARIS_SATIRLARI] WHERE DURUM<>'TAMAMLANDI' AND KONTEYNERREF=@ref),0)
IF @SAY = 0
BEGIN
UPDATE dbo.KONTEYNER SET [STATUS]=2 WHERE REF=@ref
END
END