ParaseParms() IN: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus, RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount, BookingURL,ButtonClass,'Learn More' AS ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND [EventTypeName] = 'Event' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() OUT: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus, RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount, BookingURL,ButtonClass,'Learn More' AS ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND [EventTypeName] = 'Event' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() IN: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus, RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount, BookingURL,ButtonClass,'Learn More' as ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE EventStatus = 'Open' AND Branchcode like '%[QRY-branch]%' AND AvailableOnline = 1 AND StartDate >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by StartDate ASC

ParaseParms() OUT: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus, RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount, BookingURL,ButtonClass,'Learn More' as ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE EventStatus = 'Open' AND Branchcode like '%[QRY-branch]%' AND AvailableOnline = 1 AND StartDate >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by StartDate ASC

ParaseParms() IN:

ParaseParms() OUT:

ParaseParms() IN: SELECT top 4 EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus,RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount,BookingURL,ButtonClass,ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() OUT: SELECT top 4 EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus,RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount,BookingURL,ButtonClass,ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() IN: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus,RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount,BookingURL,ButtonClass,ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() OUT: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus,RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount,BookingURL,ButtonClass,ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() IN: SELECT top 4 EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus,RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount,BookingURL,ButtonClass,ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() OUT: SELECT top 4 EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus,RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount,BookingURL,ButtonClass,ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() IN: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus, RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount, BookingURL,ButtonClass,'Learn More' AS ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND [EventTypeName] = 'Event' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() OUT: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus, RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount, BookingURL,ButtonClass,'Learn More' AS ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND [EventTypeName] = 'Event' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() IN: SELECT EventId ,EventName ,StartDateString ,ButtonText ,PublicBookingFormHeader ,'tertiary' AS EventStyle ,'fa-comments-o' AS IconStyle FROM DNNEventData WHERE EventStatus = 'Open' AND Branchcode like '%[QRY-branch]%' AND EventGroupName = 'Networking' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by StartDate ASC

ParaseParms() OUT: SELECT EventId ,EventName ,StartDateString ,ButtonText ,PublicBookingFormHeader ,'tertiary' AS EventStyle ,'fa-comments-o' AS IconStyle FROM DNNEventData WHERE EventStatus = 'Open' AND Branchcode like '%[QRY-branch]%' AND EventGroupName = 'Networking' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by StartDate ASC

ParaseParms() IN: SELECT EventId ,EventName ,StartDateString ,ButtonText ,PublicBookingFormHeader ,'secondary' AS EventStyle ,'fa-group' AS IconStyle FROM DNNEventData WHERE EventStatus = 'Open' AND EventGroupName = 'PD Event' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by StartDate ASC

ParaseParms() OUT: SELECT EventId ,EventName ,StartDateString ,ButtonText ,PublicBookingFormHeader ,'secondary' AS EventStyle ,'fa-group' AS IconStyle FROM DNNEventData WHERE EventStatus = 'Open' AND EventGroupName = 'PD Event' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by StartDate ASC

ParaseParms() IN: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus, RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount, BookingURL,ButtonClass,'Learn More' AS ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND [EventTypeName] = 'Event' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() OUT: SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus, RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount, BookingURL,ButtonClass,'Learn More' AS ButtonText,PublicBookingFormHeader FROM DNNEventData WHERE [EventStatus] = 'Open' AND [EventTypeName] = 'Event' AND AvailableOnline = 1 AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by [StartDate] ASC

ParaseParms() IN: SELECT EventId ,EventName ,StartDateString ,ButtonText ,PublicBookingFormHeader ,'secondary' AS EventStyle ,'fa-television' AS IconStyle FROM DNNEventData WHERE EventStatus = 'Open' AND EventGroupName = 'Webinar' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by StartDate ASC

ParaseParms() OUT: SELECT EventId ,EventName ,StartDateString ,ButtonText ,PublicBookingFormHeader ,'secondary' AS EventStyle ,'fa-television' AS IconStyle FROM DNNEventData WHERE EventStatus = 'Open' AND EventGroupName = 'Webinar' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by StartDate ASC

State Events

Upcoming Events

AAPM is proudly supported by our Partners.

Principal Partner

National Partners