Login
Login
Register
Search
Home
2024 Sports Medicine Conference
About SASMA
Testimonials
SASMA Personnel
History
Annual Report
Honour Board
Recognition / Awards
Henry Kneebone Prize Winners
Owen Bowering Prize Winners
Sports Trainer of the Year Award Recipients
Members
Membership Information
SASMA Members Media Library
Education Sessions
Education Working Party
SASMA Sports Medicine in General Practice Course
Sports Medicine for General Practice Pre-Readings & Resources
Sports Medicine Conference
Code of Ethics
Professional Positions Available
Mentoring
Student Membership
SPORT AND ACTIVITY COVID GUIDELINES - MEMBERS
Sports Trainers
Course Information
Level 1 Sports Trainer
Level 2 Sports Trainer
Further Education
Reaccreditation
Positions Vacant
Code of Ethics
Further Professional Development
2023 Sports Trainer Conference
Sports Trainer of the Year Awards
Uni SA Sports Trainer Placement Program
SPORT AND ACTIVITY COVID GUIDELINES - SPORTS TRAINERS
Community Services
Sideline Help Course
Emergency Response Coordinator
Concussion Management
Sports Taping Workshops
School Courses
Drugs in Sport Courses
Concussion Education Program
Resources
SSARM
Concussion
Find a Sports Medicine Professional
Injury Prevention & Management
Planning for Safer Sport
Hot Weather
Return To Sport & Recreation Series
SASMA and Maxiplast Upper Limb Taping Resources
SASMA and Maxiplast Lower Limb Taping Resources
Online Injury Reporting Database
SPORT AND ACTIVITY COVID GUIDELINES
Contact Us
SSARM
Injury Prevention Resources
Injury Prevention in Basketball
Injury Prevention in Hockey
Injury Prevention in Volleyball
Login
Register
Register
Search
You are here:
Home
>>
Event-Details
Search
Submit
2022 Sports Trainers Conference
05/06/2022 08:30 to 05/06/2022 17:00
Venue:
Payneham Library Function Centre
Details:
Details to come
Name
Event Start Date
Start Time
Event End Date
End Time
Venue
Event Description
Booking URL
Event Id
2022 Sports Trainers Conference
05/06/2022
08:30
05/06/2022
17:00
Payneham Library Function Centre
Details to come
1628
Dynamic Loaded -
Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN '
SOLD OUT
' ELSE '
Register Now
' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN '
Image Gallery
' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = [QRY-EventId]
Dynamic Alternate Loaded -
Security -
Edit Roles set to
Security -
Add Roles set to
Security -
Delete Roles set to
Using Existing Dynamic Set -
Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN '
SOLD OUT
' ELSE '
Register Now
' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN '
Image Gallery
' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = [QRY-EventId]
Executed SQL -
Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN '
SOLD OUT
' ELSE '
Register Now
' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN '
Image Gallery
' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = 1628 AND EventId LIKE '%1628%'
Select rows above and then selection an action from below to execute on your data:
Copy Record
Execute Selected Action