Roads Australia > Events

You are here: >>

Back

Roads Australia Event Details


Submit

RA Single Table Luncheon with Brendan Bourke (Melbourne)

13/08/2019 12:00 to 13/08/2019 14:30

Venue: Bar Lourinha
Details:

BY INVITATION

It's our great pleasure to host Port of Melbourne CEO, Brendan Bourke, to hear about current opportunities and challenges around freight infrastructure in Victoria.

OUR SPONSOR

OUR SPEAKER

Brendan Bourke - CEO, Port of Melbourne

As Chief Executive Officer, Brendan brings over 35 years of corporate experience and a wealth of infrastructure expertise, including in his former role as CEO of Queensland Motorways where he oversaw the successful transition of the business from government to private ownership.

Brendan is also a former Chief Operating Officer of Transurban Group, with responsibilities including serving as CEO of CityLink Melbourne for almost nine years.

BOOKING POLICY & CONDITIONS

Please note: Anyone registering for and/or attending an RA event does so on the condition and understanding that his or her name, company/organisation and title will be provided to other attendees. Registration and/or attendance also implies consent to be photographed at the event, and for those photographs to be used in various media for the purposes of promotion and publicity. Attendees’ names, organisations and/or titles may also be included in accompanying captions.

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

RA Single Table Luncheon with Brendan Bourke (Melbourne)	13/08/2019	12:00	13/08/2019	14:30	Bar Lourinha	BY INVITATION It's our great pleasure to host Port of Melbourne CEO, Brendan Bourke, to hear about current opportunities and challenges around freight infrastructure in Victoria. OUR SPONSOR OUR SPEAKER Brendan Bourke - CEO, Port of Melbourne As Chief Executive Officer, Brendan brings over 35 years of corporate experience and a wealth of infrastructure expertise, including in his former role as CEO of Queensland Motorways where he oversaw the successful transition of the business from government to private ownership. Brendan is also a former Chief Operating Officer of Transurban Group, with responsibilities including serving as CEO of CityLink Melbourne for almost nine years. BOOKING POLICY & CONDITIONS *Please note:* Anyone registering for and/or attending an RA event does so on the condition and understanding that his or her name, company/organisation and title will be provided to other attendees. Registration and/or attendance also implies consent to be photographed at the event, and for those photographs to be used in various media for the purposes of promotion and publicity. Attendees’ names, organisations and/or titles may also be included in accompanying captions.	Register Now	2084

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 = 2084 AND EventStatus <> 'Pending' AND EventId LIKE '%2084%'