Skip to content

Query: Qry ISP Performance

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • People Three Plus One ISP Contract
  • Companies
  • Positions
  • People
  • Applications
  • People Three Plus One
  • Organisational Codes

Columns Selected

  • [Organisational Codes].[Organisational Unit]
  • Count(People.[People ID])
  • Count([People Three Plus One].[Measurement Period From])
  • [ISP Incomplete]-[ISP Complete]
  • [ISP Difference]/[ISP Incomplete]
  • [ISP Complete]/[ISP Incomplete]

SQL

SELECT [Organisational Codes].[Organisational Unit], Count(People.[People ID]), Count([People Three Plus One].[Measurement Period From]), [ISP Incomplete]-[ISP Complete], [ISP Difference]/[ISP Incomplete], [ISP Complete]/[ISP Incomplete] FROM [People], [People Three Plus One], [Applications], [Positions], [Organisational Codes], [Companies], [People Three Plus One ISP Contract]