| 487 | Adelaide Hills AAPM Hot Topics Tuesday | Tuesday June 26 2018 | 15:30 | 17:15 | https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=487 | Thank you for registering to attend this networking session, we look forward to seeing you on the day. All AAPM networking events are run by AAPM volunteers, so if you are unable to make it to this event, we would sincerely appreciate it if you could please let us know a few days in advance. Places are limited at these events and if you are unable to attend, your place can be offered to someone else. |
| 503 | North West AAPM Networking Group | Thursday June 28 2018 | 12:30 | 13:30 | https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=503 | |
| 504 | Launceston AAPM Networking Group | Thursday June 28 2018 | 12:30 | 13:30 | https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=504 | |
| 513 | AAPM Richmond Networking Breakfast | Thursday June 28 2018 | 08:00 | 09:00 | https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=513 | Thank you for registering to attend this networking session, we look forward to seeing you on the day. All AAPM networking events are run by AAPM volunteers, so if you are unable to make it to this event, we would sincerely appreciate it if you could please let us know a few days in advance. Places are limited at these events and if you are unable to attend, your place can be offered to someone else. |
| 519 | Cairns Networking Event over Breakfast | Thursday June 28 2018 | 07:00 | 08:45 | https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=519 | Thank you for registering to attend this networking session, we look forward to seeing you on the day. All AAPM networking events are run by AAPM volunteers, so if you are unable to make it to this event, we would sincerely appreciate it if you could please let us know a few days in advance. Places are limited at these events and if you are unable to attend, your place can be offered to someone else. |
| 510 | South Coast Network Breakfast of Champions | Monday July 2 2018 | 07:00 | 08:00 | https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=510 | Thank you for registering to attend this networking session, we look forward to seeing you on the day. All AAPM networking events are run by AAPM volunteers, so if you are unable to make it to this event, we would sincerely appreciate it if you could please let us know a few days in advance. Places are limited at these events and if you are unable to attend, your place can be offered to someone else. |
| 497 | Hunter Network Dinner | Tuesday July 3 2018 | 18:30 | 21:00 | https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=497 | |
| 393 | Webinar #11 - HPSS and Nurses Award | Thursday July 5 2018 | 13:00 | 14:00 | https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=393 | 2018 AAPM Webinar #11 - HPSS and Nurses Award |
Standard Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Standard Alternate Loaded -
Executed SQL - Select top 8
EventId
,[Event Name]
,DATENAME(dw, [Event Start Date])+ ' ' + DATENAME(mm, [Event Start Date]) + ' ' + DATENAME(d, [Event Start Date]) + ' ' + DATENAME(YYYY, [Event Start Date]) AS [Event Start Date]
,[Event Start Time]
,[Event End Time]
,'https://aapm.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,PublicBookingFormHeader
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 [Event Start Date] > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE()))
order by event.StartDate
Select rows above and then selection an action from below to execute on your data:
Execute Selected Action