D&O Class Actions - Panel Discussion
An APIG QLD Event
01/05/2025 12:00 to 01/05/2025 14:00
Venue: ,
Details:
Book Here
| APIG QLD | D&O Class Actions - Panel Discussion | 01/05/2025 | 12:00 | 01/05/2025 | 14:00 | | | | https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=266 | 266 |
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 '%266%'
Select rows above and then selection an action from below to execute on your data:
Execute Selected Action