ALTER PROCEDURE [dbo].[usp_ExamGetStudentForInsertMarsk] ( @Class INT, @Term INT, @Session NVARCHAR(50) ) AS BEGIN SELECT [photo] ,[RegistrationNo] AS 'Reg.No' ,[Name] ,[FatherName] AS 'Fname' ,s.[Session] ,lstC.Description 'Class' FROM [dbo].[Student] s LEFT JOIN [dbo].[ExamData] e ON s.RegistrationNo = e.studentID left join [dbo].[ListTypesData] lstC ON s.CurrentClass = lstC.ListTypeDataId WHERE CurrentClass = @Class AND (e.Term != @Term or e.Term is null) AND s.Session= @Session AND (s.IsLeft != 1 OR s.IsLeft IS NULL) END
MINUS
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)