Assuming gender is required, the following 2 results were found.
123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML...
the info we want is rather simple: SELECT [sequenceID], [student_reference], [student_title_code], [student_name], [student_gender_code], [student_country_birth_code], [student_country_domicile_code], [student_nationality_code], [student_ethnicity_code]...