Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Back
HumanResources vEmployeeDepartmentHistory (view)
Modified on 2011/08/27 11:17
by
wikibot
Categorized as
Uncategorized
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''View''' | HumanResources.vEmployeeDepartmentHistory |- valign="top" | '''Description''' | Returns employee name and current and previous departments. |} === Source === {{{{<nowiki> CREATE VIEW [HumanResources].[vEmployeeDepartmentHistory] AS SELECT e.[EmployeeID] ,c.[Title] ,c.[FirstName] ,c.[MiddleName] ,c.[LastName] ,c.[Suffix] ,s.[Name] AS [Shift] ,d.[Name] AS [Department] ,d.[GroupName] ,edh.[StartDate] ,edh.[EndDate] FROM [HumanResources].[Employee] e INNER JOIN [Person].[Contact] c ON c.[ContactID] = e.[ContactID] INNER JOIN [HumanResources].[EmployeeDepartmentHistory] edh ON e.[EmployeeID] = edh.[EmployeeID] INNER JOIN [HumanResources].[Department] d ON edh.[DepartmentID] = d.[DepartmentID] INNER JOIN [HumanResources].[Shift] s ON s.[ShiftID] = edh.[ShiftID]; </nowiki>}}}} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Select | Table | [[HumanResources Department (table)|HumanResources.Department]] |- valign="top" | Select | Table | [[HumanResources Employee (table)|HumanResources.Employee]] |- valign="top" | Select | Table | [[HumanResources EmployeeDepartmentHistory (table)|HumanResources.EmployeeDepartmentHistory]] |- valign="top" | Select | Table | [[HumanResources Shift (table)|HumanResources.Shift]] |- valign="top" | Select | Table | [[Person Contact (table)|Person.Contact]] |- valign="top" | Schema | Schema | [[HumanResources (schema)|HumanResources]] |}
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.