Dataset: SalesEmployees
Property | Value |
Data source name | |
Referenced data set | SalesEmployees |
Command type |
Name | Source column | Data type | Caption | Value | Is calculated field |
BusinessEntityID | BusinessEntityID | System.Int32 | |||
Employee | Employee | System.String | |||
JobTitle | JobTitle | System.String |
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] |