Generated using SQL Data Dictionary demo version.
Returns employee name and current and previous departments.
| Column | Data Type | Nullable |
|---|---|---|
| BusinessEntityID | int | |
| Title | nvarchar(8) | X |
| FirstName | Name(nvarchar(50)) | |
| MiddleName | Name(nvarchar(50)) | X |
| LastName | Name(nvarchar(50)) | |
| Suffix | nvarchar(10) | X |
| Shift | Name(nvarchar(50)) | |
| Department | Name(nvarchar(50)) | |
| GroupName | Name(nvarchar(50)) | |
| StartDate | date | |
| EndDate | date | X |