I have to write a trigger, I have status approval table when there is status update from inactive to active or inactive to rejected, this trigger should fire.
the table structure for storing email is as below:
create table tbl_emaildetails
ID int not null identity(1,1),
user_profile_id int not null
sp to get the Template text and email address is as below:
create procedure sp_emaildetails_view
can any one suggest me how to write trigger for the above scenario.
Thanks & Regards,