Report

USE tempdb;

IF OBJECT_ID('ReportStudentList', 'P') IS NOT NULL
  DROP PROC ReportStudentList
GO
CREATE PROC ReportStudentList
AS

SELECT SG.id GroupId, SG.Number [Номер группы], S.id StudentId, S.FIO [ФИО]
FROM GroupStudent SG
  JOIN Student S ON S.GroupId = SG.Id
ORDER BY 1, 2