Example SIMS query that links photos to EasyBadge database

SELECT a.[surname] as 'Surname'

      ,a.[midname] as 'Midname'

      ,a.[chosen_forename] as 'Forename'

      ,b.admission_number as 'Id Number'

      ,a.[gender]

      ,a.[Roll_Mode]

      ,a.[Photo] as 'Image'

      ,a.[current_reg_code]

  FROM [SIMS].[sims].[sta_vix_StudentBrowse_Browse_WithPhoto] a, [SIMS].[sims].[stud_via_student_browse] b

  where a.person_id = b.person_id

  and a.roll_mode='On Roll'

and (current_year_code='12' or current_year_code='13')

  order by surname asc