WayneW
Last Activity: Oct 25 '07, 02:40 PM
Joined: Nov 28 '06
Location:
-
It depends on what you want in the result. If you want the manager name next to the employee, use this script. -
*************** *************** *************** *************** *************
SELECT dbo.DEPT_TABLE. DEPTNO, dbo.DEPT_TABLE. DNAME, dbo.DEPT_TABLE. LOC, dbo.EMP_TABLE.E MPNO, dbo.EMP_TABLE.E NAME, dbo.EMP_TABLE.M GRNO, EMP_TABLE_1.ENA ME AS Manager
FROM dbo.DEPT_TABLE INNER JOIN
dbo.EMP_TABLE ON dbo.DEPT_TABLE. DEPTNO = dbo.EMP_TABLE.D EPTNO INNER JOIN
dbo.EMP_TABLE AS EMP_TABLE_1 ON dbo.EMP_TABLE.M GRNO = EMP_TABLE_1.EMP NO...Leave a comment:
-
Triggers in SQL 2005
I wrote some triggers in SQL 2000, and could update etc them through the User interface in the design screen.
Where has this been moved in SQL 2005. -
Can one create a view in MS SQL across databases
I need to create a view of tables in 2 databases. Is this possible? -
the trigger date is a date field which must then fire the procedure, not a user input option.
ThanksLeave a comment:
-
MS SQL Script writer
Hi,
I'm new to MS SQL. Is there a tool that will create.automate script creation which I can then read through. -
How do I create an Insert trigger to copy a table
HI,
I need to create a trigger that will
1.copy all the records of a table to another table in the same database when and entrydate > 31/01/2007.
2. Delete the contents of the source table
Can anyone help me
No activity results to display
Leave a comment: