Sorry to disturb you again,Pls check and correct the code

Declare @CurStudent cursor

Declare @Name VARCHAR(100)

Declare @Dept_ID INT

Declare @Department VARCHAR(100)

Declare @Fees NUMERIC(10,4)

Declare @StudentStatus varchar(100)

Declare @DOJ DATETIME

CREATE table #tempTable(TempName VARCHAR(100), TempDept_ID INT,TempDepartment VARCHAR(100),

TempFees NUMERIC(10,4),TempStudentStatus varchar(100),TempDOJ DATETIME )

SET @CurStudent = CURSOR FOR

SELECT Name,Dept_ID,Department,Fees,StudentStatus,DOJ FROM StudentDatamy

OPEN @CurStudent

FETCH NEXT FROM @CurStudent INTO @Name,@Dept_ID,@Department,@Fees,@StudentStatus,@DOJ

WHILE @@FETCH_STATUS = 0

BEGIN

INSERT #tempTable values(@Name,@Dept_ID,@Department,@Fees,@StudentStatus,@DOJ)

FETCH NEXT FROM @CurStudent INTO @Name,@Dept_ID,@Department,@Fees,@StudentStatus,@DOJ

SELECT TempDepartment,SUM(@Fees)AS TotalFee FROM #tempTable

GROUP BY TempDepartment

End