Roads Australia > Events

You are here: >>

Back

Roads Australia Event Details


Submit

RA Honorary Board Dinner for David Stuart-Watt (Sydney)

06/02/2020 18:30 to 06/02/2020 21:30

Venue: Doltone House
Details:

BY INVITATION

Each year as part of the RA Board's Annual Workshop we host a small but high-powered dinner of industry leaders.

This year's Board Dinner will have an added dimension as we formally thank our outgoing President David Stuart-Watt for his years of service to Roads Australia.

This will be a stellar networking event to kick off 2020, as well as an opportunity to acknowledge a true champion of the Australian roads industry.

OUR SPEAKERS

Duncan Gay, former NSW Roads Minister

Duncan held the NSW roads portfolio for almost six years, from 2011 to 2017. During that period (which coincided with David's Presidency of RA), he was a strong supporter of Roads Australia and the role it played as a 'bridge' between industry and government.

As such, we've asked Duncan to come back and reflect on the organisation's growth and evolving influence under David's watch, and what it means for the next chapter of RA's story.

OUR SPONSORS

Image Gallery

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

RA Honorary Board Dinner for David Stuart-Watt (Sydney)	06/02/2020	18:30	06/02/2020	21:30	Doltone House	BY INVITATION Each year as part of the RA Board's Annual Workshop we host a small but high-powered dinner of industry leaders. This year's Board Dinner will have an added dimension as we formally thank our outgoing President David Stuart-Watt for his years of service to Roads Australia. This will be a stellar networking event to kick off 2020, as well as an opportunity to acknowledge a true champion of the Australian roads industry. OUR SPEAKERS Duncan Gay, former NSW Roads Minister Duncan held the NSW roads portfolio for almost six years, from 2011 to 2017. During that period (which coincided with David's Presidency of RA), he was a strong supporter of Roads Australia and the role it played as a 'bridge' between industry and government. As such, we've asked Duncan to come back and reflect on the organisation's growth and evolving influence under David's watch, and what it means for the next chapter of RA's story. OUR SPONSORS	Image Gallery	2125

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