Skip to content

Query: SubQry Rpt Average Time Through Pipeline Criteria

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

Tables Referenced

  • Temp
  • Pipelines
  • Temp Entrepreneur Steps
  • Entrepreneurs
  • Distribution Models
  • Delivery Locations

Columns Selected

  • Pipeline
  • Entrepreneurs.[First Name]
  • Surname
  • [Temp Entrepreneur Steps].[Entrepreneur ID]
  • [Distribution Models].[Distribution Model]
  • [Delivery Locations].[Delivery Location]
  • DateDiff(\
  • Month([Step 8 First Date])
  • [Temp Entrepreneur Steps].[Step 8 First Date]
  • Year([Step 8 First Date])

SQL

SELECT Pipelines.Pipeline, Entrepreneurs.[First Name], Entrepreneurs.Surname, [Temp Entrepreneur Steps].[Entrepreneur ID], [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location], DateDiff(\, Month([Step 8 First Date]), [Temp Entrepreneur Steps].[Step 8 First Date], Year([Step 8 First Date]) FROM [Temp Entrepreneur Steps], [Entrepreneurs], [Delivery Locations], [Distribution Models], [Pipelines]