APIG NSW 2025 Autumn Soiree
An APIG NSW Event
03/04/2025 16:00 to 03/04/2025 19:00
Venue: The Establishment, 252 George Street, SYDNEY, NSW, 2000, AUSTRALIA,
Details:
Autumn Soiree
APIG NSW would like to invite you to our first networking event of 2025 as we bid farewell to the end of daylight savings.
Buy your fellow colleague, broker, insurer or lawyer a ticket and join us for a late afternoon soiree.
Can you think of any better way to celebrate the start of Autumn?
Book Here
APIG NSW | APIG NSW 2025 Autumn Soiree | 03/04/2025 | 16:00 | 03/04/2025 | 19:00 | The Establishment | 252 George Street, SYDNEY, NSW, 2000, AUSTRALIA, | Autumn Soiree
APIG NSW would like to invite you to our first networking event of 2025 as we bid farewell to the end of daylight savings.
Buy your fellow colleague, broker, insurer or lawyer a ticket and join us for a late afternoon soiree.
Can you think of any better way to celebrate the start of Autumn?
| https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=264 | 264 |
Dynamic Loaded -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1
Dynamic Alternate Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Using Existing Dynamic Set -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1
Executed SQL -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1 AND EventId LIKE '%264%'
Select rows above and then selection an action from below to execute on your data:
Execute Selected Action