CREATE PROC [dbo].[STOK_RAPOR_SEPET_DURUM_GUNCELLEMESI]
(@TARIH VARCHAR(50), @ID TINYINT)
AS
BEGIN
DECLARE @DURUM TINYINT
SET @DURUM = ISNULL((SELECT STA FROM dbo.STOK_RAPOR_SEPET_LISTESI WHERE ORDERDATE=@TARIH AND USERID=@ID),0) 
IF @DURUM = 0 
BEGIN
UPDATE dbo.STOK_RAPOR_SIPARISLER SET STATUS_=1 WHERE ORDERDATE=@TARIH AND USERID=@ID
END
ELSE
BEGIN
UPDATE dbo.STOK_RAPOR_SIPARISLER SET STATUS_=0 WHERE ORDERDATE=@TARIH AND USERID=@ID
END
END