Skip to content

Query: Qry Report Marketing EOI to Passed Panel

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

Tables Referenced

  • Temp Lead Type for Lead Report
  • Temp
  • SubQry Rpt Marketing EOI to Passed Panel Count EOI
  • SubQry Rpt Marketing EOI to Passed Panel Count Qualified
  • SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel
  • Lead Types

Columns Selected

  • [Temp Lead Type for Lead Report].[Lead Type ID]
  • [Lead Types].[Lead Type]
  • [SubQry Rpt Marketing EOI to Passed Panel Count EOI].[Number of EOI]
  • [SubQry Rpt Marketing EOI to Passed Panel Count Qualified].[Number Qualified]
  • [SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel].[Number Passed Pan
  • [Number Passed Panel]/[Number Qualified]

SQL

SELECT [Temp Lead Type for Lead Report].[Lead Type ID], [Lead Types].[Lead Type], [SubQry Rpt Marketing EOI to Passed Panel Count EOI].[Number of EOI], [SubQry Rpt Marketing EOI to Passed Panel Count Qualified].[Number Qualified], [SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel].[Number Passed Pan, [Number Passed Panel]/[Number Qualified] FROM [Temp Lead Type for Lead Report], [Lead Types], [SubQry Rpt Marketing EOI to Passed Panel Count EOI], [SubQry Rpt Marketing EOI to Passed Panel Count Qualified], [SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel]