April 5, 2013 at 3:00 am
By using Trigger i need to get the sum(salary) of Employee's from employee table,on tanother table,send me the code
April 5, 2013 at 3:33 am
andrewalex.r (4/5/2013)
By using Trigger i need to get the sum(salary) of Employee's from employee table,on tanother table,send me the code
How can any human who lacks supernatural powers provide code for your unknown table structures? See the link in my signature for details on how to provide the level of detail required.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
April 5, 2013 at 3:56 am
MY employee Table contain CREATE TABLE EmployeeTable(ID INT IDENTITY NOT NULL PRIMARY KEY,Department_ID INT,
Employee_Name VARCHAR(100),Designation VARCHAR(100),Salary BIGINT,DOJ DATETIME)
I think these r the requirments u need........
April 5, 2013 at 4:03 am
andrewalex.r (4/5/2013)
MY employee Table contain CREATE TABLE EmployeeTable(ID INT IDENTITY NOT NULL PRIMARY KEY,Department_ID INT,Employee_Name VARCHAR(100),Designation VARCHAR(100),Salary BIGINT,DOJ DATETIME)
I think these r the requirments u need........
Please read the link. Here[/url] it is again, as you seem to have been unable to find it.
You have provided no sample data, no details of the second table, no reason as to why you are planning on using a trigger rather than a view, no details of the circumstances under which you would like the trigger to fire ...
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply