Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need help Expand / Collapse
Author
Message
Posted Friday, April 5, 2013 3:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, May 5, 2013 11:56 PM
Points: 12, Visits: 29
By using Trigger i need to get the sum(salary) of Employee's from employee table,on tanother table,send me the code
Post #1439131
Posted Friday, April 5, 2013 3:33 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:08 AM
Points: 4,981, Visits: 11,673
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.




Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1439138
Posted Friday, April 5, 2013 3:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, May 5, 2013 11:56 PM
Points: 12, Visits: 29
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........
Post #1439143
Posted Friday, April 5, 2013 4:03 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:08 AM
Points: 4,981, Visits: 11,673
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 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 ...



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1439144
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse