i have a table as follows:

create table "ITMS_JobCardAc torStatusHistor y" (
"jobCardNo" int identity not null,
"issueID" int not null,
"assignedTo " char(5) not null, /*this is emp id*/
"assignedDa te" datetime not null,
"closedDate " datetime null,
"jobFixDescript ion" varchar(100) null,
"estimatedT ime" int null)...