Skip to content

Query: Qry Report Selection Daily Team Activity

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

Tables Referenced

  • SubQry Rpt Count Entrepreneurs With Pipeline Moves
  • SubQry Rpt Get Owned By
  • SubQry Rpt Count Meetings by Owned By
  • SubQry Rpt Count Terminations by Owned By
  • SubQry
  • SubQry Rpt Count Unqualified by Owned By
  • SubQry Rpt Count Entrepreneurs In the Pipeline

Columns Selected

  • OwnedBy
  • [SubQry Rpt Count Entrepreneurs In the Pipeline].[Number of EPs Pipeline]
  • [SubQry Rpt Count Entrepreneurs With Pipeline Moves].[Number of EPs Moved]
  • [Number of EPs Moved]/[Number of EPs Pipeline]
  • [SubQry Rpt Count Meetings by Owned By].[Number of Meetings]
  • [SubQry Rpt Count Terminations by Owned By].[Number of Terminations]
  • [SubQry Rpt Count Unqualified by Owned By].[Number of Unqualified]

SQL

SELECT [SubQry Rpt Get Owned By].OwnedBy, [SubQry Rpt Count Entrepreneurs In the Pipeline].[Number of EPs Pipeline], [SubQry Rpt Count Entrepreneurs With Pipeline Moves].[Number of EPs Moved], [Number of EPs Moved]/[Number of EPs Pipeline], [SubQry Rpt Count Meetings by Owned By].[Number of Meetings], [SubQry Rpt Count Terminations by Owned By].[Number of Terminations], [SubQry Rpt Count Unqualified by Owned By].[Number of Unqualified] FROM [SubQry Rpt Get Owned By], [SubQry Rpt Count Entrepreneurs In the Pipeline], [SubQry Rpt Count Entrepreneurs With Pipeline Moves], [SubQry Rpt Count Meetings by Owned By], [SubQry Rpt Count Terminations by Owned By], [SubQry Rpt Count Unqualified by Owned By]