Broker’s liability
An APIG SA Event
24/10/2023 12:30 to 24/10/2023 14:00
Venue: DW Fox Tucker Lawyers, Level 14, , 96-100 King William Street, ADELAIDE, SA, 5000, AUSTRALIA,
Details:
Sam Hurburgh joined Anthony Mason Chambers in July 2023. He was previously a solicitor for 12 years at Minter Ellison Lawyers in its insurance law team. Sam has broad experience in civil litigation, predominantly in professional indemnity, professional disciplinary, dust diseases, building and construction, personal injury, and public liability. He has significant experience representing finance and insurance professionals, and their insurers, in civil and commercial disputes.
Book Here
| APIG SA | Broker’s liability | 24/10/2023 | 12:30 | 24/10/2023 | 14:00 | DW Fox Tucker Lawyers | Level 14, , 96-100 King William Street, ADELAIDE, SA, 5000, AUSTRALIA, | Sam Hurburgh joined Anthony Mason Chambers in July 2023. He was previously a solicitor for 12 years at Minter Ellison Lawyers in its insurance law team. Sam has broad experience in civil litigation, predominantly in professional indemnity, professional disciplinary, dust diseases, building and construction, personal injury, and public liability. He has significant experience representing finance and insurance professionals, and their insurers, in civil and commercial disputes.
| https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=232 | 232 |
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 '%232%'
Select rows above and then selection an action from below to execute on your data:
Execute Selected Action