I need to Get the utilization in the hour format of HH:MM .......

K, I need to change the format of the Date

Company_ID Employee_ID In_Time Out_Time Remarks Entry_Date

17921Task Completed ...

MY employee Table contain CREATE TABLE EmployeeTable(ID INT IDENTITY NOT NULL PRIMARY KEY,Department_ID INT,

Employee_Name VARCHAR(100),Designation VARCHAR(100),Salary BIGINT,DOJ DATETIME)

I think these r the requirments u need........

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...

Since i am starter in sql,they ask me to create a table with student data that include (Dept_ID,Name,Department,Fees,StudentStatus,DOJ)

and they ask to retrive the data into another table which contains sum(fees)...