use medical


INSERT INTO lab_data  (pdf, chartnumber, date_entered, batch, [date], checked, [key], order_id, order_flag, uid, is_pdf, code, is_old_pdf)  SELECT  pdf, chartnumber, date_created, batch, date, checked, [key], order_id, order_flag, uid, - 1 AS Expr1, 'OBX' AS Expr2, -1 as EXPR3  FROM  lab_paper where code='PDF'

go

INSERT INTO lab_data   (data, chartnumber, date_entered, batch, [date], checked, [key], order_id, order_flag, uid, is_html, code, is_old_pdf)  SELECT  html, chartnumber, date_created, batch, date, checked, [key], order_id, order_flag, uid, - 1 AS Expr1, 'OBX' AS Expr2, -1 as exp4  FROM  lab_paper where code='HTML'

go

INSERT INTO lab_data
                         (data, seq, chartnumber, ibid, uid, code, batch, flag, date, [key], test, HL7, units, range, result, test_id, HL7_seq, checked, order_id, order_flag)
SELECT            data, seq, chartnumber, ibid, uid, code, batch, flag, date, [key], test, hl7, units, range, result, test_id, HL7_seq, checked, order_id, order_flag
FROM            lab_page