Dataset: SalesEmployees
Dataset properties
| Property | Value |
| Data source name | |
| Referenced data set | SalesEmployees |
| Command type |
Parameters
Fields
| Name | Source column | Data type | Caption | Value | Is calculated field |
| BusinessEntityID | BusinessEntityID | System.Int32 | |||
| Employee | Employee | System.String | |||
| JobTitle | JobTitle | System.String |
Filters
Query
SELECT s.[BusinessEntityID], p.[FirstName] + N' ' + p.LastName AS Employee, e.[JobTitle] FROM [Sales].[SalesPerson] s INNER JOIN [HumanResources].[Employee] e ON e.[BusinessEntityID] = s.[BusinessEntityID] INNER JOIN [Person].[Person] p ON p.[BusinessEntityID] = s.[BusinessEntityID] |
See also