USE [JMC6] GO /****** Object: StoredProcedure [dbo].[sp_Display_batch_students_attendance_percentage_report] Script Date: 06-06-2025 16:18:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[sp_Display_batch_students_attendance_percentage_report] @batch_id uniqueidentifier, @class_from_date date, @class_upto_date date as begin UPDATE dbo.class SET class_start_time = ISNULL((SELECT MIN(adtLog) FROM class_faculty_view WHERE (class_id = dbo.class.class_id)), dbo.class.class_end_time) WHERE (dbo.class.class_id = dbo.class.class_id) DECLARE @from_date datetime, @upto_date datetime set @from_date = @class_from_date set @upto_date = DATEADD(DAY,1,@class_upto_date) set @upto_date = DATEADD(SECOND,-1,@upto_date) SELECT id ,enroll_id ,roll_no ,enroll_name ,department_id ,department_name ...