Skip to content

Query: Qry Report Writer

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

Tables Referenced

  • vwPurpleGetLastNotebyEntrepreneur
  • Lead Types
  • Principal Projects
  • Products
  • Entrepreneur Company
  • Principals
  • IndustryLookup
  • ProcessStatus
  • Entrepreneurs
  • Qry Get Current Contract Info by Company
  • Delivery Locations

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]
  • [Qry Get Current Contract Info by Company].[Principal Project ID]
  • Entrepreneurs.[Process Status ID]
  • [First Name] & \
  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company].[Company Name]
  • ProcessStatus.[Step Number]
  • Status
  • Gender
  • Entrepreneurs.[Identity Number]
  • Entrepreneurs.[Date of Birth]
  • [Lead Types].[Lead Type]
  • Province
  • [Delivery Locations].[Delivery Location]
  • OwnedBy
  • Location
  • Entrepreneurs.[Information 1]
  • Entrepreneurs.[Information 2]
  • Entrepreneurs.[Information 3]
  • Industry
  • [Entrepreneur Company].[Business Registration Date]
  • [Entrepreneur Company].[Sworn Affidavit Date]
  • CompanyReg
  • [Entrepreneur Company].[Brief Description of Business]
  • [Entrepreneur Company].[Average Monthly Turnover]
  • [Entrepreneur Company].[Years in Business]
  • Principal
  • [Qry Get Current Contract Info by Company].[Principal Project]
  • Product
  • [Qry Get Current Contract Info by Company].[Total Programme Amount]
  • [Qry Get Current Contract Info by Company].[BBBEE Pillar]
  • [Qry Get Current Contract Info by Company].[Total Allocated Amt]
  • Entrepreneurs.[Telephone Number]
  • Entrepreneurs.[Email Address]
  • [Entrepreneur Company].[BEE Level]
  • [Entrepreneur Company].[Percentage Black Owned]
  • [Entrepreneur Company].[Percentage Women Black Owned]
  • [Principals].[Principal] & \
  • Product
  • Entrepreneurs.[Process Date]
  • IIf([Entrepreneurial Assessment Results]=1,\
  • Entrepreneurs.[EA Marker]
  • IIf([PP Results]=1,\
  • vwPurpleGetLastNotebyEntrepreneur.[Note Date]
  • Notes

SQL

SELECT Entrepreneurs.[Entrepreneur ID], [Qry Get Current Contract Info by Company].[Principal Project ID], Entrepreneurs.[Process Status ID], [First Name] & \, [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], ProcessStatus.[Step Number], ProcessStatus.Status, Entrepreneurs.Gender, Entrepreneurs.[Identity Number], Entrepreneurs.[Date of Birth], [Lead Types].[Lead Type], Entrepreneurs.Province, [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, Entrepreneurs.Location, Entrepreneurs.[Information 1], Entrepreneurs.[Information 2], Entrepreneurs.[Information 3], IndustryLookup.Industry, [Entrepreneur Company].[Business Registration Date], [Entrepreneur Company].[Sworn Affidavit Date], [Entrepreneur Company].CompanyReg, [Entrepreneur Company].[Brief Description of Business], [Entrepreneur Company].[Average Monthly Turnover], [Entrepreneur Company].[Years in Business], [Qry Get Current Contract Info by Company].Principal, [Qry Get Current Contract Info by Company].[Principal Project], [Qry Get Current Contract Info by Company].Product, [Qry Get Current Contract Info by Company].[Total Programme Amount], [Qry Get Current Contract Info by Company].[BBBEE Pillar], [Qry Get Current Contract Info by Company].[Total Allocated Amt], Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address], [Entrepreneur Company].[BEE Level], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned], [Principals].[Principal] & \, Products.Product, Entrepreneurs.[Process Date], IIf([Entrepreneurial Assessment Results]=1,\, Entrepreneurs.[EA Marker], IIf([PP Results]=1,\, vwPurpleGetLastNotebyEntrepreneur.[Note Date], vwPurpleGetLastNotebyEntrepreneur.Notes FROM [IndustryLookup], [Entrepreneurs], [ProcessStatus], [Lead Types], [Principal Projects], [Principals], [Entrepreneur Company], [Products], [Delivery Locations], [Qry Get Current Contract Info by Company], [vwPurpleGetLastNotebyEntrepreneur]