insert into tblabbarcodingmaster (Requestnum,Refnum,Idnum,Hospnum,Barcode,Itemid,
								  SpecimenId,Sectionid, ResultStatus,RequestStatus,LISid,Commstat)
				select requestnum,Refnum,Idnum,Hospnum,Barcode,Itemid,
				       Specimenid,SectionId,ResultStatus, 'X','HCLAB','X'
					   from tblabmaster where  Refnum='C8119I'

insert into tblabmaster (Barcode, Refnum, Hospnum,Idnum,Roomid,
                         Requeststatus,SectionId,ItemId,Amount,Transdate,
						 patientType,RUSH,DoctorId,SpecimenId,Quantity, UserId)
			select 'XC8119IM2', Refnum,Hospnum,Idnum,'OPD',
			        'X','C', '212',Amount,Transdate,
					'O','N', '', '2', Quantity,UserId
			from billing..tbBillopdailyout where Refnum='C8119I' and RevenueId='LB' and Itemid='212'



If @@Error <> 0
   Begin
     goto SaveError;
   End

Commit Tran;
Return 0;

SaveError:
   Rollback Tran;
   Return @@Error;

Begin Tran;