Dataset: SalesEmployees

CollapseAll image

Collapse image Dataset properties


 Property   Value 
 Data source name    
 Referenced data set   SalesEmployees 
 Command type    

Collapse image Parameters


No parameters exist

Collapse image Fields


Name  Source column  Data type  Caption  Value  Is calculated field 
BusinessEntityID BusinessEntityID System.Int32      
Employee Employee System.String      
JobTitle JobTitle System.String      
Total: 3 field(s)

Collapse image Filters


No filters exist

Collapse image 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]

Collapse image See also


About this documentation