i am creating a trigger on the below table D0086readingtabletD0010IDREGIDMPANREADINGSETTLEMENTDATEMeterRegisterIdBSCValidationStatusReadingTypeENTRYTYPEBILLID1105681745023800003667660036872211120192V E D0086 NULL1105671745023800003667660083435211120191V E D0086 NULLSo whenever the D0010id 110567 data will insertit will go for logic inside triggerIs it possible like After 2 rows insert with the same registraion idthe logic will take placeALTER TRIGGER

Execute Trigger after Insert two record in SQL Server

chetan

i am creating a trigger on the below table : D0086_reading_table_t

So whenever the D0010_id 110567 data will insert,it will go for logic inside trigger.

Is it possible like After 2 rows insert with the same registraion id,the logic will take place.

ALTER TRIGGER [dbo].[CHANGE_SUPPLIER_D0300_TG]
ON [dbo].[D0086_CHANGE_SUPPLIER_READING_DET_T]
AFTER INSERT
AS 
BEGIN
END

dharmend...

0 1

No it is not possible to call after 2 row insert.

Because when an record will inserted the trigger executed.

But inside the trigger you can check row count and implement the logic you want.