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
Ethics in Sport (Professional Education)
20/04/2021 19:00 to 20/04/2021 21:00
Venue:
Live Webcast
Details:
Time:
7:00pm - 9:00pm
Speakers + Panel Discussion
Presenters:
Anthony Crocker
Barrister
This session will be presented via a live webcast.
Name
Event Start Date
Start Time
Event End Date
End Time
Venue
Event Description
Booking URL
Event Id
Ethics in Sport (Professional Education)
20/04/2021
19:00
20/04/2021
21:00
Live Webcast
Time:
7:00pm - 9:00pm
Speakers + Panel Discussion
Presenters:
Anthony Crocker
Barrister
This session will be presented via a live webcast.
1528
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 = 1528 AND EventId LIKE '%1528%'
Select rows above and then selection an action from below to execute on your data:
Copy Record
Execute Selected Action