insert into tblabmaster (Barcode, Hospnum, idnum, roomId,refnum,RequestStatus,
SectionID, ItemId, Amount,Transdate,PatientType,DoctorId,SpecimenId,UserId,Rush,Quantity,RequestFormPrintDate,
ItemCharged,PhysicianId)
select Barcode, Hospnum, idnum, roomId,refnum,'X',
SectionID, '231', '80',Transdate,PatientType,DoctorId,SpecimenId,UserId,'N',Quantity,RequestFormPrintDate,
ItemCharged,PhysicianId from tblabmaster 
where Refnum='C7758I' and itemId='252'