Roads Australia > Events

You are here: >>

Back

Roads Australia Event Details


Submit

RA Single Table Luncheon with Glen Mace (Sydney)

13/04/2021 12:00 to 13/04/2021 14:30

Venue: Doltone House (Tribute)
Details:

BY INVITATION

Join us as we host Glen Mace, Head of Sydney Project Delivery, Infrastructure & Place, Transport for NSW, for a single table luncheon. This lunch is an ideal opportunity to directly engage in a discussion regarding the delivery of Transport for NSW's infrastructure project pipeline and its focus on ensuring projects demonstrate positive economic, social and environmental benefits for the community.

Date: Tuesday 13 April 2021

Time: 12pm pre luncheon drinks for a 12.30pm prompt sit down; 2.30pm close

Where: Doltone House (Tribute), 26-32 Pirrama Road, Pyrmont

Diet: Please inform us if you have special dietary requirements

For booking queries, please contact Director - Events, Rachael Rooney.

OUR SPONSOR

OUR SPEAKER

Glen Mace, Head of Sydney Project Delivery, Infrastructure & Place, Transport for NSW

Glen leads the delivery accountability for transport (non-heavy rail) infrastructure and place related projects and outcomes as commissioned by the Greater Sydney Division, including detailed project planning, construction management, commissioning, and provides guidance on delivery management to ensure major projects are delivered safely, to a high quality and on budget, with minimum impact to the community and environment.

Image Gallery

Name	Event Start Date	Start Time	Event End Date	End Time	Venue	Event Description	Booking URL	Event Id

RA Single Table Luncheon with Glen Mace (Sydney)	13/04/2021	12:00	13/04/2021	14:30	Doltone House (Tribute)	BY INVITATION Join us as we host Glen Mace, Head of Sydney Project Delivery, Infrastructure & Place, Transport for NSW, for a single table luncheon. This lunch is an ideal opportunity to directly engage in a discussion regarding the delivery of Transport for NSW's infrastructure project pipeline and its focus on ensuring projects demonstrate positive economic, social and environmental benefits for the community. Date: Tuesday 13 April 2021 Time: 12pm pre luncheon drinks for a 12.30pm prompt sit down; 2.30pm close Where: Doltone House (Tribute), 26-32 Pirrama Road, Pyrmont Diet: Please inform us if you have special dietary requirements For booking queries, please contact Director - Events, Rachael Rooney. OUR SPONSOR OUR SPEAKER Glen Mace, Head of Sydney Project Delivery, Infrastructure & Place, Transport for NSW Glen leads the delivery accountability for transport (non-heavy rail) infrastructure and place related projects and outcomes as commissioned by the Greater Sydney Division, including detailed project planning, construction management, commissioning, and provides guidance on delivery management to ensure major projects are delivered safely, to a high quality and on budget, with minimum impact to the community and environment.	Image Gallery	3267

Dynamic Loaded - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = [QRY-EventId] AND EventStatus <> 'Pending'
Dynamic Alternate Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Using Existing Dynamic Set - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = [QRY-EventId] AND EventStatus <> 'Pending'
Executed SQL - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = 3267 AND EventStatus <> 'Pending' AND EventId LIKE '%3267%'