I have #tbl_GRN_Detail in which issue_ID col exit,i want when i insert row into table #tbl_issuance ,it check in #tbl_GRN_Detail that Issue_ID value is null then insert into #tbl_issuance other not.
i am using trigger for Updating issue_ID in #tbl_issuance from table of #tbl_GRN_DEtail.
I tried to used IF NOT EXISTS in SP ,but it is not working properly
Create table #tbl_GRN_Detail (D_ID int,GRN_ID int,item_code int,Issue_ID int)
Insert into #tbl_GRN_Detail values (11001,2001,22,Null)
Create table #tbl_issuance (issue_ID int,item_code int,Issue_Date int,D_ID int)
IF NOT EXISTS(Select Issue_ID from tbl_GRN_Detail
where Issue_ID=@Issue_ID and Issue_ID is not null)
begin
Insert into #tbl_issuance values (101,22,'2021-06-28',11001)
end
CREATE TRIGGER issuance_tri ON tbl_issuance AFTER INSERT AS
UPDATE tbl_GRN_Detail
SET Issue_ID = i.issue_ID
FROM tbl_GRN_Detail G
JOIN inserted i ON G.D_ID = i.D_ID
go


