Hi Every one
This is my procedure. I want to first Delete data if exist. After that I want to insert data into table
How to make false condition false, if data exist and delete statement runs for one time. After that It should excecute only insert statement . How to do it
thanks
ALTER procedure [dbo].[SP_Delivery_InsertUpdate]
(
@DELIVERY_STATION varchar(20)
,@DDRNO varchar(7)
,@DDRDATE date
--,@oldDELIVERY_STATION varchar(40)
-- ,@oldDDRNO varchar(7)
,@CODE_NAME varchar (20)
,@CNMT varchar (7)
,@NOPKG varchar (6)
,@WEIGHT varchar (6)
,@FREIGHT varchar(14)
,@DC varchar (2)
,@GATEPASS varchar (7)
,@REBATE varchar(10)
,@OTHER varchar(10)
,@WGR varchar (1)
,@EDATE date
,@OP_CODE varchar (1)
)
as
begin
declare @Dele int
set @Dele=0;
IF EXISTS (SELECT * FROM DELIVERY WHERE DELIVERY_STATION=@DELIVERY_STATION and DDRNO=@DDRNO)
IF(@Dele=0)
BEGIN
delete from DELIVERY
WHERE DELIVERY_STATION=@DELIVERY_STATION AND DDRNO=@DDRNO
set @Dele=1
END
else
if(@Dele=1)
BEGIN
insert INTO DELIVERY (DELIVERY_STATION ,DDRNO,DDRDATE,CODE_NAME,CNMT,NOPKG,WEIGHT,FREIGHT,DC,GATEPASS,REBATE,OTHER,WGR,EDATE,OP_CODE)
values(@DELIVERY_STATION , @DDRNO,@DDRDATE,@CODE_NAME,@CNMT,@NOPKG,@WEIGHT,@FREIGHT,@DC,@GATEPASS,@REBATE,@OTHER,@WGR,@EDATE,@OP_CODE)
END
END