Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [RTOManager_Demo]
- GO
- /****** Object: StoredProcedure [dbo].[Proc_GEL_StudentClassFetchForGEL] Script Date: 6/10/2022 12:32:51 PM ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ----Procedure to fetch student class information for GEL integration
- ----Created By: Yuvaraj Upadhyaya
- ----Created date: May 25 2022
- ALTER PROCEDURE [dbo].[Proc_GEL_StudentClassFetchForGEL]
- @StudentId nvarchar(100)
- AS
- BEGIN
- ----- In case of any change please maintain column names as below:
- ----- StudentId,ClassID,ClassType,ClassName,ClassRoom,ClassTeacher,ClassTime,ClassFromDate, ClassToDate, ChangedTime
- SELECT top 1 * FROM (
- SELECT DISTINCT sr.studentId,c.ClassID,sr.SubjectId AS ClassType,c.Batch AS ClassName,r.RoomName AS ClassRoom,st.FirstName + ' ' + st.LastName AS ClassTeacher,
- StartTime AS ClassTime, sr.SubjectStartDate AS ClassFromDate,sr.SubjectFinishDate AS ClassToDate,
- (SELECT MAX(ChangedTime) FROM Class_Log WHERE ClassId = c.ClassID) AS ChangedTime
- FROM studentresults sr
- INNER JOIN class c ON c.SubjectID=sr.SubjectID AND c.BlockID=sr.BlockID AND c.Batch=sr.Batch AND c.CampusID=sr.CampusID
- INNER JOIN classmode cm ON cm.ClassID=c.ClassID
- INNER JOIN room r ON r.RoomID=cm.RoomId
- INNER JOIN Staff st ON st.UserName=cm.Teacherid
- WHERE StudentId = @StudentId
- ) a
- WHERE ChangedTime IS NOT NULL
- ORDER BY ChangedTime DESC
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement