Jorhat JMC sp_Display_batch_students_attendance_percentage_report update

 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

      ,batch_id

      ,batch_name

      ,[session_id]

      ,session_name

      ,class_of_department_id

      ,class_of_department_name AS class_subject_or_department

  ,(SELECT COUNT(class_id) AS Expr1 FROM dbo.periodic_report_view WHERE (class_of_date BETWEEN @from_date AND @upto_date) AND (uid = dbo.enrollment_of_class_view.id) AND (class_subject_or_department = dbo.enrollment_of_class_view.class_of_department_name)) AS total_number_of_class

  ,(SELECT COUNT(class_id) AS Expr1 FROM dbo.periodic_report_view WHERE (class_of_date BETWEEN @from_date AND @upto_date) AND (uid = dbo.enrollment_of_class_view.id) AND (class_subject_or_department = dbo.enrollment_of_class_view.class_of_department_name) AND (class_status = 'P')) AS total_number_of_present

  ,(SELECT COUNT(class_id) AS Expr1 FROM dbo.periodic_report_view WHERE (class_of_date BETWEEN @from_date AND @upto_date) AND (uid = dbo.enrollment_of_class_view.id) AND (class_subject_or_department = dbo.enrollment_of_class_view.class_of_department_name) AND (class_status = 'A')) AS total_number_of_absent   

  FROM dbo.enrollment_of_class_view

  WHERE batch_id = @batch_id

  AND ((SELECT COUNT(class_id) AS Expr1 FROM dbo.periodic_report_view WHERE (class_of_date BETWEEN @from_date AND @upto_date) AND (uid = dbo.enrollment_of_class_view.id) AND (class_subject_or_department = dbo.enrollment_of_class_view.class_of_department_name)) > 0)


  

End


Comments

Post a Comment

Popular posts from this blog

Full Stack Web Development

  HTML Tutorial CSS Tutorial JavaScript Tutorial React Tutorial Bootstrap 5 Tutorial Node.js Tutorial Node.js Tutorial Key Components of Full Stack Development 1. Front-End (Client Side) This is what the user sees and interacts with. Languages & Technologies: HTML (Structure) CSS (Styling) JavaScript (Interactivity) Popular Frameworks/Libraries: React.js Angular Vue.js SASS / Tailwind CSS / Bootstrap 2. Back-End (Server Side) Handles the business logic, database interactions, and authentication. Languages & Frameworks: Node.js (JavaScript) Express.js Python (Django, Flask) Ruby on Rails Java (Spring Boot) PHP (Laravel) Database Management: SQL Databases: MySQL, PostgreSQL NoSQL Databases: MongoDB, Firebase
Read more

Reading Substring value from string excel data in c#

1. Form1.cs  using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.IO; using System.Data.SqlClient; namespace mspc {     public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }         private SqlConnection cn = new SqlConnection(Properties.Settings.Default.cnstr);         public void ConnectionOpen()         {             try             {                 if (cn.State != ConnectionState.Open) cn.Open();             }             ca...
Read more

Nodemon (automatically restarting the Node.js server)

 npm ps1 is not loaded because of running script is desable how to solve ChatGPT said: The error you're encountering is typically related to the execution policy in PowerShell, which restricts the running of scripts for security reasons. By default, PowerShell doesn't allow scripts to run unless the execution policy is set to allow them. To resolve this issue, you need to change the execution policy to allow scripts to run. Here are the steps to fix this issue: Open PowerShell as Administrator : Press Windows + X and choose Windows PowerShell (Admin) or Command Prompt (Admin) . Check the current execution policy (optional): In the PowerShell window, run this command to check the current execution policy: powershell Copy Get-ExecutionPolicy It will likely return Restricted , which is preventing the script from running. Set the execution policy to allow scripts : To allow scripts to run, use the following command: powershell Copy Set-ExecutionPolicy RemoteSi...
Read more