2024 Annual APIG National Conference and Gala Dinner
An APIG Event
19/09/2024 07:45 to 19/09/2024 23:00
Venue: Sofitel Sydney Wentworth, 61-101 Phillip Street, SYDNEY, NSW, 2000, AUSTRALIA,
Details:
The 2024 Annual APIG National Conference and Gala Dinner will bring together key industry participants as an opportunity to educate, network and canvass new ideas.
Our 2024 program has an impressive line-up of speakers both from within our industry and beyond and will cover a range of topical issues affecting our industry.
For full details, please go to https://www.apig.com.au/Conference/2024-Conference.
We look forward to seeing you there!
Book Here
| APIG | 2024 Annual APIG National Conference and Gala Dinner | 19/09/2024 | 07:45 | 19/09/2024 | 23:00 | Sofitel Sydney Wentworth | 61-101 Phillip Street, SYDNEY, NSW, 2000, AUSTRALIA, | The 2024 Annual APIG National Conference and Gala Dinner will bring together key industry participants as an opportunity to educate, network and canvass new ideas.
Our 2024 program has an impressive line-up of speakers both from within our industry and beyond and will cover a range of topical issues affecting our industry.
For full details, please go to https://www.apig.com.au/Conference/2024-Conference.
We look forward to seeing you there!
| https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=241 | 241 |
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 '%241%'
Select rows above and then selection an action from below to execute on your data:
Execute Selected Action