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 ,LEFT(DATENAME(mm,StartDate),3) AS StartMonth ,DATENAME(dd,StartDate) AS StartDay ,DATENAME(yyyy,StartDate) AS StartYear ,StartTime ,VenueName ,EventName ,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 ,LEFT(DATENAME(mm,StartDate),3) AS StartMonth ,DATENAME(dd,StartDate) AS StartDay ,DATENAME(yyyy,StartDate) AS StartYear ,StartTime ,VenueName ,EventName ,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 ,LEFT(DATENAME(mm,StartDate),3) AS StartMonth ,DATENAME(dd,StartDate) AS StartDay ,DATENAME(yyyy,StartDate) AS StartYear ,StartTime ,VenueName ,EventName ,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 ,LEFT(DATENAME(mm,StartDate),3) AS StartMonth ,DATENAME(dd,StartDate) AS StartDay ,DATENAME(yyyy,StartDate) AS StartYear ,StartTime ,VenueName ,EventName ,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 ,LEFT(DATENAME(mm,StartDate),3) AS StartMonth ,DATENAME(dd,StartDate) AS StartDay ,DATENAME(yyyy,StartDate) AS StartYear ,StartTime ,VenueName ,EventName ,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 ,LEFT(DATENAME(mm,StartDate),3) AS StartMonth ,DATENAME(dd,StartDate) AS StartDay ,DATENAME(yyyy,StartDate) AS StartYear ,StartTime ,VenueName ,EventName ,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 ,LEFT(DATENAME(mm,StartDate),3) AS StartMonth ,DATENAME(dd,StartDate) AS StartDay ,DATENAME(yyyy,StartDate) AS StartYear ,StartTime ,VenueName ,EventName ,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 ,LEFT(DATENAME(mm,StartDate),3) AS StartMonth ,DATENAME(dd,StartDate) AS StartDay ,DATENAME(yyyy,StartDate) AS StartYear ,StartTime ,VenueName ,EventName ,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 ,StartDateString ,ButtonText ,PublicBookingFormHeader ,CASE EventGroupName WHEN 'Networking' THEN 'tertiary' WHEN 'Webinar' THEN 'secondary' ELSE 'primary' END AS EventStyle ,CASE EventGroupName WHEN 'Networking' THEN 'fa-comments-o' WHEN 'Webinar' THEN 'fa-television' ELSE 'fa-group' END AS IconStyle 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 ,StartDateString ,ButtonText ,PublicBookingFormHeader ,CASE EventGroupName WHEN 'Networking' THEN 'tertiary' WHEN 'Webinar' THEN 'secondary' ELSE 'primary' END AS EventStyle ,CASE EventGroupName WHEN 'Networking' THEN 'fa-comments-o' WHEN 'Webinar' THEN 'fa-television' ELSE 'fa-group' END AS IconStyle 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 ,StartDateString ,ButtonText ,PublicBookingFormHeader ,CASE EventGroupName WHEN 'Networking' THEN 'tertiary' WHEN 'Webinar' THEN 'secondary' ELSE 'primary' END AS EventStyle ,CASE EventGroupName WHEN 'Networking' THEN 'fa-comments-o' WHEN 'Webinar' THEN 'fa-television' ELSE 'fa-group' END AS IconStyle 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 ,StartDateString ,ButtonText ,PublicBookingFormHeader ,CASE EventGroupName WHEN 'Networking' THEN 'tertiary' WHEN 'Webinar' THEN 'secondary' ELSE 'primary' END AS EventStyle ,CASE EventGroupName WHEN 'Networking' THEN 'fa-comments-o' WHEN 'Webinar' THEN 'fa-television' ELSE 'fa-group' END AS IconStyle 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: 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 ,StartDateString ,ButtonText ,PublicBookingFormHeader ,CASE EventGroupName WHEN 'Networking' THEN 'tertiary' WHEN 'Webinar' THEN 'secondary' ELSE 'primary' END AS EventStyle ,CASE EventGroupName WHEN 'Networking' THEN 'fa-comments-o' WHEN 'Webinar' THEN 'fa-television' ELSE 'fa-group' END AS IconStyle 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 ,StartDateString ,ButtonText ,PublicBookingFormHeader ,CASE EventGroupName WHEN 'Networking' THEN 'tertiary' WHEN 'Webinar' THEN 'secondary' ELSE 'primary' END AS EventStyle ,CASE EventGroupName WHEN 'Networking' THEN 'fa-comments-o' WHEN 'Webinar' THEN 'fa-television' ELSE 'fa-group' END AS IconStyle 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 ,StartDateString ,ButtonText ,PublicBookingFormHeader ,CASE EventGroupName WHEN 'Networking' THEN 'tertiary' WHEN 'Webinar' THEN 'secondary' ELSE 'primary' END AS EventStyle ,CASE EventGroupName WHEN 'Networking' THEN 'fa-comments-o' WHEN 'Webinar' THEN 'fa-television' ELSE 'fa-group' END AS IconStyle 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 ,StartDateString ,ButtonText ,PublicBookingFormHeader ,CASE EventGroupName WHEN 'Networking' THEN 'tertiary' WHEN 'Webinar' THEN 'secondary' ELSE 'primary' END AS EventStyle ,CASE EventGroupName WHEN 'Networking' THEN 'fa-comments-o' WHEN 'Webinar' THEN 'fa-television' ELSE 'fa-group' END AS IconStyle 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:

Latest News

Most Recent

Upcoming Events