alter table deliverynote add SalesOrderNo nvarchar(500)
go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Trg_DeliveryNoteChk] ON [dbo].[DeliveryNote]
 Instead of  INSERT
AS 
BEGIN

DECLARE @Process  as char(10);
declare @po as varchar(100);
select @po=inserted.DNNo from inserted


SET @Process =(CASE WHEN EXISTS(SELECT * FROM INSERTED )AND EXISTS(SELECT * FROM DELETED) THEN 'U'
				WHEN EXISTS(SELECT * FROM INSERTED) THEN 'I' END)


     if (select count(*) from inserted i inner join DeliveryNote p on i.DNNo=p.DNNo)>=1
	   begin
	   rollback
update setup set svalue=@po where code='DNNo'
      end
    else
       
       Begin
       update setup set svalue=@po where code='DNNo'
INSERT INTO [dbo].[DeliveryNote]([EntryDate],[QuotationNo],[RefNo],[PONo],[DNNo],[BillType],[CustomerCode],[CustomerName],[Telephone],[Fax],[Attended],
[GrossAmount],[Discount],[NetAmount],[KeyFld],[Less],[Status],[Attention],[Remarks],[InvoiceNo],[Address],[Flag],[UserName],[emailAttention],
[mobAttention],[del1],[del2],[del3],[del4],[podate],[InvDate],[deleted],[Mobile],[Vatno],TOTALCOST,DISPER,DISAMT,DISNET
,Detail1,Detail2,Detail3,Detail4,Detail5,Detail6,Detail7,Detail8,Detail9,Detail10,DetailDate1,DetailDate2,DetailDate3,DetailDate4,vattotal,SalesOrderNo)
select Inserted.[EntryDate],Inserted.[QuotationNo],Inserted.[RefNo],Inserted.[PONo],Inserted.[DNNo],Inserted.[BillType],Inserted.[CustomerCode],
Inserted.[CustomerName],Inserted.[Telephone],Inserted.[Fax],Inserted.[Attended],Inserted.[GrossAmount],Inserted.[Discount],Inserted.[NetAmount],
Inserted.[KeyFld],Inserted.[Less],Inserted.[Status],Inserted.[Attention],Inserted.[Remarks],Inserted.[InvoiceNo],Inserted.[Address],Inserted.[Flag],
Inserted.[UserName],Inserted.[emailAttention],Inserted.[mobAttention],Inserted.[del1],Inserted.[del2],Inserted.[del3],Inserted.[del4],Inserted.[podate],
Inserted.[InvDate],Inserted.[deleted],Inserted.[Mobile],Inserted.[Vatno] ,INSERTED.TOTALCOST,INSERTED.DISPER,INSERTED.DISAMT,INSERTED.DISNET ,Inserted.Detail1,Inserted.Detail2,Inserted.Detail3,Inserted.Detail4,Inserted.Detail5,Inserted.Detail6,Inserted.Detail7,Inserted.Detail8,Inserted.Detail9,Inserted.Detail10,
Inserted.DetailDate1,Inserted.DetailDate2,Inserted.DetailDate3,Inserted.DetailDate4,Inserted.vattotal,inserted.SalesOrderNo
from Inserted
END
END