CREATE PROC [dbo].[KONTEYNER_SATIRLARI_DURUM_GUNCELLEME]
(@DURUM VARCHAR(100), @RF INT)
AS
BEGIN
DECLARE @DURUMID INT
SET @DURUMID = ISNULL((SELECT [REF] FROM [IHR].[dbo].[KONTEYNER] WHERE [FICHENO]=@DURUM), 0)
UPDATE [IHR].[dbo].[FICHE_LINES] SET [STATUS]=5 WHERE [REF]=@RF
UPDATE [IHR].[dbo].[FICHE_LINES] SET [KONTEYNERREF]=@DURUMID WHERE [REF]=@RF
END