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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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 ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply