Skip to content

Query: SubQry Rpt Part Sponsorship

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

Tables Referenced

  • Qry Sum Total Allocated Amt by Company
  • Qry
  • vwPurpleReportPartSponsorship

Columns Selected

  • vwPurpleReportPartSponsorship.[Entrepreneur Company ID]
  • vwPurpleReportPartSponsorship.[Company Programme Year Status ID]
  • vwPurpleReportPartSponsorship.[Programme Year Status]
  • vwPurpleReportPartSponsorship.[Lump Sum Allocation]
  • vwPurpleReportPartSponsorship.[Company Status ID]
  • vwPurpleReportPartSponsorship.[Company Status]
  • vwPurpleReportPartSponsorship.[Date Status Changed]
  • vwPurpleReportPartSponsorship.[Status Modified By]
  • vwPurpleReportPartSponsorship.[Company Delivery Location ID]
  • vwPurpleReportPartSponsorship.[Delivery Location]
  • vwPurpleReportPartSponsorship.[Company Name]
  • Industry
  • vwPurpleReportPartSponsorship.[Percentage Black Owned]
  • vwPurpleReportPartSponsorship.[Percentage Women Black Owned]
  • vwPurpleReportPartSponsorship.[Brief Description of Business]
  • Product
  • vwPurpleReportPartSponsorship.[Total Programme Amount]
  • vwPurpleReportPartSponsorship.[Total Selection Fee]
  • vwPurpleReportPartSponsorship.[Programme Year]

Order By

vwPurpleReportPartSponsorship.[Company Name]

SQL

SELECT vwPurpleReportPartSponsorship.[Entrepreneur Company ID], vwPurpleReportPartSponsorship.[Company Programme Year Status ID], vwPurpleReportPartSponsorship.[Programme Year Status], vwPurpleReportPartSponsorship.[Lump Sum Allocation], vwPurpleReportPartSponsorship.[Company Status ID], vwPurpleReportPartSponsorship.[Company Status], vwPurpleReportPartSponsorship.[Date Status Changed], vwPurpleReportPartSponsorship.[Status Modified By], vwPurpleReportPartSponsorship.[Company Delivery Location ID], vwPurpleReportPartSponsorship.[Delivery Location], vwPurpleReportPartSponsorship.[Company Name], vwPurpleReportPartSponsorship.Industry, vwPurpleReportPartSponsorship.[Percentage Black Owned], vwPurpleReportPartSponsorship.[Percentage Women Black Owned], vwPurpleReportPartSponsorship.[Brief Description of Business], vwPurpleReportPartSponsorship.Product, vwPurpleReportPartSponsorship.[Total Programme Amount], vwPurpleReportPartSponsorship.[Total Selection Fee], vwPurpleReportPartSponsorship.[Programme Year] FROM [Qry Sum Total Allocated Amt by Company], [vwPurpleReportPartSponsorship]