start...! Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140911710' as PID , '11141557212' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141557212_ASHOK JAIN_L9201_26Nov2014_ 172013.pdf' as filepath, 'ASHOK JAIN' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140950824' as PID , '11141584927' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141584927_DEVENDER SINGH CHAWLA_L9206_04Dec2014_ 180934.pdf' as filepath, 'DEVENDER SINGH CHAWLA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140904689' as PID , '11141552180' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141552180_PRAKASH MLWANI_L9201_25Nov2014_ 153830.pdf' as filepath, 'PRAKASH MLWANI' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140979527' as PID , '11141605451' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141605451_WILSON MUNJANAHU_L9205_10Dec2014_ 194543.pdf' as filepath, 'WILSON MUNJANAHU' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140937700' as PID , '11141575659' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141575659_AVINASH HAVALDAR_L9205_02Dec2014_ 143357.pdf' as filepath, 'AVINASH HAVALDAR' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140959280' as PID , '11141590772' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141590772_DOG LEO_L9201_06Dec2014_ 144930.pdf' as filepath, 'DOG LEO' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140959468' as PID , '11141590934' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141590934_GIRANAND PANDEY_L9205_06Dec2014_ 150754.pdf' as filepath, 'GIRANAND PANDEY' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140965794' as PID , '11141595550' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141595550_HITESH SHAH_L9202_08Dec2014_ 145939.pdf' as filepath, 'HITESH SHAH' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140918798' as PID , '11141562393' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141562393_M A RAZZAK_L9201_28Nov2014_ 110602.pdf' as filepath, 'M A RAZZAK' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140864504' as PID , '11141523537' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141523537_PARVEEN SHAH_L9205_17Nov2014_ 200253.pdf' as filepath, 'PARVEEN SHAH' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140873347' as PID , '11141529600' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141529600_SHRINIWASAN IYER_L9205_19Nov2014_ 141915.pdf' as filepath, 'SHRINIWASAN IYER' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140859450' as PID , '11141519762' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141519762_SUDHAKAR SHETTY_17Nov2014_ 112757.pdf' as filepath, 'SUDHAKAR SHETTY' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140934479' as PID , '11141573646' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141573646_HASMUKH SHAH_L9202_01Dec2014_ 180616.pdf' as filepath, 'HASMUKH SHAH' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140931722' as PID , '11141571576' as OID , 'L9207' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141571576_KALPANA GALA_L9207_01Dec2014_ 140839.pdf' as filepath, 'KALPANA GALA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140894113' as PID , '11141544770' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141544770_NILESH BAROSKAR_L9202_22Nov2014_ 203121.pdf' as filepath, 'NILESH BAROSKAR' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140942249' as PID , '11141578809' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141578809_PRAKASH PHALAK_L9202_03Dec2014_ 131435.pdf' as filepath, 'PRAKASH PHALAK' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140864496' as PID , '11141523529' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141523529_RICHARD DSOUZA_L9205_17Nov2014_ 200134.pdf' as filepath, 'RICHARD DSOUZA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140885658' as PID , '11141538392' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141538392_RUSSEL JOHN_L9205_21Nov2014_ 153816.pdf' as filepath, 'RUSSEL JOHN' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140961465' as PID , '11141592410' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141592410_SAIDEEP JADHAV_L9206_06Dec2014_ 182109.pdf' as filepath, 'SAIDEEP JADHAV' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140850952' as PID , '11141513710' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141513710_VICTOR PODDER_L9205_14Nov2014_ 190846.pdf' as filepath, 'VICTOR PODDER' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140945912' as PID , '11141581549' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141581549_GIRANAND PANDEY_L9205_03Dec2014_ 192056.pdf' as filepath, 'GIRANAND PANDEY' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140956396' as PID , '11141588990' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141588990_MANOJ MEHTA_L9206_05Dec2014_ 193054.pdf' as filepath, 'MANOJ MEHTA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140943580' as PID , '11141579732' as OID , 'L9207' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141579732_RAJESH P PUNAMIA_L9207_03Dec2014_ 151554.pdf' as filepath, 'RAJESH P PUNAMIA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140950851' as PID , '11141584952' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141584952_AJAY RANALKAR_L9206_04Dec2014_ 181241.pdf' as filepath, 'AJAY RANALKAR' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140973780' as PID , '11141601251' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141601251_BANWARILAL GUPTA_L9206_09Dec2014_ 192825.pdf' as filepath, 'BANWARILAL GUPTA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140959532' as PID , '11141590986' as OID , 'L9204' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141590986_DR PRATIKSHA GANDHI_L9204_06Dec2014_ 151340.pdf' as filepath, 'DR PRATIKSHA GANDHI' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140945330' as PID , '11141581051' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141581051_JAYPRAKASH KHOT_L9202_03Dec2014_ 181531.pdf' as filepath, 'JAYPRAKASH KHOT' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140849353' as PID , '11141512301' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141512301_MOLLY JOY_L9206_14Nov2014_ 163127.pdf' as filepath, 'MOLLY JOY' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140945900' as PID , '11141581538' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141581538_NITINRAJ ARAYADATH_L9205_03Dec2014_ 191933.pdf' as filepath, 'NITINRAJ ARAYADATH' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140860626' as PID , '11141520577' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141520577_PARVEEN SHAH_L9205_17Nov2014_ 135424.pdf' as filepath, 'PARVEEN SHAH' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140934464' as PID , '11141573631' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141573631_PRABHAKAR PAWAR_L9202_01Dec2014_ 180405.pdf' as filepath, 'PRABHAKAR PAWAR' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140875939' as PID , '11141531547' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141531547_SHRINIWASAN IYER_L9205_19Nov2014_ 181638.pdf' as filepath, 'SHRINIWASAN IYER' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140939443' as PID , '11141576956' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141576956_SUNIDHI MISHRA_L9202_02Dec2014_ 170148.pdf' as filepath, 'SUNIDHI MISHRA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140867529' as PID , '11141525332' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141525332_WILSON MUNJANATTU_L9205_18Nov2014_ 151227.pdf' as filepath, 'WILSON MUNJANATTU' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140868350' as PID , '11141525925' as OID , 'L9204' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141525925_CAPTAIN MOGUL_L9204_18Nov2014_ 161627.pdf' as filepath, 'CAPTAIN MOGUL' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140965646' as PID , '11141595426' as OID , 'L9204' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141595426_CHANDRASHEKHAR MORE_L9204_08Dec2014_ 144303.pdf' as filepath, 'CHANDRASHEKHAR MORE' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140956595' as PID , '11141589178' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141589178_DEEPAK VASWANI_L9201_05Dec2014_ 202758.pdf' as filepath, 'DEEPAK VASWANI' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140948833' as PID , '11141583427' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141583427_DR SHRIPAD KANEKAR_L9205_04Dec2014_ 150541.pdf' as filepath, 'DR SHRIPAD KANEKAR' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140882370' as PID , '11141536235' as OID , 'L9207' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141536235_GITANJALI PRABHU_L9207_20Nov2014_ 200259.pdf' as filepath, 'GITANJALI PRABHU' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140870166' as PID , '11141527449' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141527449_KIRAN CHHABRA_L9201_18Nov2014_ 191424.pdf' as filepath, 'KIRAN CHHABRA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140983406' as PID , '11141607959' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141607959_MALLINATH GHUGARE 31337_L9201_11Dec2014_ 163448.pdf' as filepath, 'MALLINATH GHUGARE 31337' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140911721' as PID , '11141557221' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141557221_MASTER LEO_L9201_26Nov2014_ 172128.pdf' as filepath, 'MASTER LEO' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140881823' as PID , '11141535734' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141535734_NARENDRA NAIK_L9201_20Nov2014_ 184956.pdf' as filepath, 'NARENDRA NAIK' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140894107' as PID , '11141544764' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141544764_NEERAJ KUMAR_L9202_22Nov2014_ 202708.pdf' as filepath, 'NEERAJ KUMAR' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140880204' as PID , '11141534465' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141534465_T S SITARAM_L9201_20Nov2014_ 160533.pdf' as filepath, 'T S SITARAM' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140844640' as PID , '11141508977' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141508977_ALAKNANDA ROY_L9201_13Nov2014_ 180807.pdf' as filepath, 'ALAKNANDA ROY' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140971133' as PID , '11141599194' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141599194_BANWARILAL GUPTA_L9206_09Dec2014_ 145236.pdf' as filepath, 'BANWARILAL GUPTA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140971155' as PID , '11141599210' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141599210_BANWARILAL GUPTA_L9206_09Dec2014_ 145431.pdf' as filepath, 'BANWARILAL GUPTA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140862381' as PID , '11141521780' as OID , 'L9204' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141521780_CAPTAIN HOSHI MOGUL_L9204_17Nov2014_ 162231.pdf' as filepath, 'CAPTAIN HOSHI MOGUL' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140951156' as PID , '11141585228' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141585228_DR SHRIPAD KANEKOR_L9205_04Dec2014_ 184822.pdf' as filepath, 'DR SHRIPAD KANEKOR' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140917687' as PID , '11141561621' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141561621_FAKHRUDDIN LOKHANDWALA_L9201_27Nov2014_ 180506.pdf' as filepath, 'FAKHRUDDIN LOKHANDWALA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140968281' as PID , '11141597438' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141597438_HITESH SHAH_L9202_08Dec2014_ 191741.pdf' as filepath, 'HITESH SHAH' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140849364' as PID , '11141512310' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141512310_JOY NINAN_L9206_14Nov2014_ 163237.pdf' as filepath, 'JOY NINAN' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140860598' as PID , '11141520552' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141520552_KEVIN JACINTO_L9205_17Nov2014_ 135157.pdf' as filepath, 'KEVIN JACINTO' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140907288' as PID , '11141554283' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141554283_PUSHPALATA AMBRASE_L9205_25Nov2014_ 202232.pdf' as filepath, 'PUSHPALATA AMBRASE' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140935042' as PID , '11141574118' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141574118_RUSSEL JOHN_L9205_01Dec2014_ 192321.pdf' as filepath, 'RUSSEL JOHN' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140937661' as PID , '11141575627' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141575627_SATISH VISAPURE_L9205_02Dec2014_ 142934.pdf' as filepath, 'SATISH VISAPURE' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140937684' as PID , '11141575647' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141575647_SATISH VISAPURE_L9205_02Dec2014_ 143219.pdf' as filepath, 'SATISH VISAPURE' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140865458' as PID , '11141524048' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141524048_SHAIKH BADRE ALAM_L9201_18Nov2014_ 113215.pdf' as filepath, 'SHAIKH BADRE ALAM' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140882516' as PID , '11141536379' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141536379_TEJRAM BANSAL_L9206_20Nov2014_ 201855.pdf' as filepath, 'TEJRAM BANSAL' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140856189' as PID , '11141517298' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141517298_BINU SABU_L9206_15Nov2014_ 180141.pdf' as filepath, 'BINU SABU' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140904702' as PID , '11141552189' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141552189_CHERIE SALDANHA_L9201_25Nov2014_ 153925.pdf' as filepath, 'CHERIE SALDANHA' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140967393' as PID , '11141596660' as OID , 'L9207' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141596660_DUTT GIRI_L9207_08Dec2014_ 173527.pdf' as filepath, 'DUTT GIRI' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140945623' as PID , '11141581298' as OID , 'L9202' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141581298_JAYPRAKASH KHOT_L9202_03Dec2014_ 184731.pdf' as filepath, 'JAYPRAKASH KHOT' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140891374' as PID , '11145027126' as OID , 'L9201' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11145027126_MOHAMMED ABDULLAH_L9201_22Nov2014_ 153122.pdf' as filepath, 'MOHAMMED ABDULLAH' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140961452' as PID , '11141592399' as OID , 'L9206' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141592399_NITIN JADHAV_L9206_06Dec2014_ 181853.pdf' as filepath, 'NITIN JADHAV' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140850916' as PID , '11141513676' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141513676_PRASHANT PURANIK_L9205_14Nov2014_ 190155.pdf' as filepath, 'PRASHANT PURANIK' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140853410' as PID , '11141515218' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141515218_PRASHANT PURANIK_L9205_15Nov2014_ 140245.pdf' as filepath, 'PRASHANT PURANIK' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 91 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select 'P11140888227' as PID , '11141540458' as OID , 'L9205' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , 'Report-11141540458_RUSSEL JOHN_L9205_21Nov2014_ 200453.pdf' as filepath, 'RUSSEL JOHN' as Patient_name, 'MUMBAI' as location From XML_PATIENT ; Connected Location DELHISERVER Select distinct a.HPTCODE as HLABNO, a.HLABNO as OID, a.HCOLCD as CLIENTCD, a.HPATNAM AS Patient_name, e.EPDFNAME as filepath from MLREGHDR a WITH (NOLOCK) left join MLPATMAS b WITH (NOLOCK) on a.HPTCODE = b.PTCODE left join MLREGDTL d WITH (NOLOCK) on a.HLABNO = d.DTLABNO left join MLREPORTEMAILPDF e WITH (NOLOCK) on a.HLABNO = e.ESID where a.HPATNAM NOT LIKE '%DUMMY%' and a.HFINDATE Is NOT NULL and a.HCOLCD in ('L0615','L0616','L0617','L0618') and a.HPTCODE <> '0' order by a.HPTCODE desc; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 262 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select '270001' as PID , '140090003' as OID , 'L0617' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , '2014\\11\\29\\140090003_G_R_NAGENDRAN_29Nov2014_181810_WL.pdf' as filepath, 'G R NAGENDRAN' as Patient_name, 'DELHISERVER' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 262 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select '230002' as PID , '140070005' as OID , 'L0618' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , '2014\\12\\5\\140070005_VINOD_KUMAR_SALUJA_05Dec2014_164628_WL.pdf' as filepath, 'VINOD KUMAR SALUJA' as Patient_name, 'DELHISERVER' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 262 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select '230002' as PID , '140070006' as OID , 'L0618' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , '2014\\12\\5\\140070006_VINOD_KUMAR_SALUJA_05Dec2014_170003_WL.pdf' as filepath, 'VINOD KUMAR SALUJA' as Patient_name, 'DELHISERVER' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 262 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select '230001' as PID , '140070003' as OID , 'L0618' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , '2014\\12\\3\\140070003_RAKESH_KUMAR_03Dec2014_180325_WL.pdf' as filepath, 'RAKESH KUMAR' as Patient_name, 'DELHISERVER' as location From XML_PATIENT ; Notice: Undefined index: ACCID in /var/www/html/mhl/Lifrespan_xml_export.php on line 262 INSERT IGNORE INTO `XML_PATIENT`( `PID`, `OID`, `CLIENTCD`, `ACCID` , `Filepath`, `Patient_name` , location ) select '230001' as PID , '140070004' as OID , 'L0618' as CLIENTCD , concat ('6001NG000' , (max(id)+1)) as ACCID , '2014\\12\\4\\140070004_RAKESH_KUMAR_04Dec2014_094816_WL.pdf' as filepath, 'RAKESH KUMAR' as Patient_name, 'DELHISERVER' as location From XML_PATIENT ; Connected Location KOLKATA Select distinct a.HPTCODE as HLABNO, a.HLABNO as OID, a.HCOLCD as CLIENTCD, a.HPATNAM AS Patient_name, e.EPDFNAME as filepath from MLREGHDR a WITH (NOLOCK) left join MLPATMAS b WITH (NOLOCK) on a.HPTCODE = b.PTCODE left join MLREGDTL d WITH (NOLOCK) on a.HLABNO = d.DTLABNO left join MLREPORTEMAILPDF e WITH (NOLOCK) on a.HLABNO = e.ESID where a.HPATNAM NOT LIKE '%DUMMY%' and a.HFINDATE Is NOT NULL and a.HCOLCD in ('L0106','L0108') and a.HPTCODE <> '0' order by a.HPTCODE desc; Connected Location AHMEDABAD Select distinct a.HPTCODE as HLABNO, a.HLABNO as OID, a.HCOLCD as CLIENTCD, a.HPATNAM AS Patient_name, e.EPDFNAME as filepath from MLREGHDR a WITH (NOLOCK) left join MLPATMAS b WITH (NOLOCK) on a.HPTCODE = b.PTCODE left join MLREGDTL d WITH (NOLOCK) on a.HLABNO = d.DTLABNO left join MLREPORTEMAILPDF e WITH (NOLOCK) on a.HLABNO = e.ESID where a.HPATNAM NOT LIKE '%DUMMY%' and a.HFINDATE Is NOT NULL and a.HCOLCD in ('L0354','L0355 ','L0352','L0353') and a.HPTCODE <> '0' order by a.HPTCODE desc; Connected Location HYDERABAD Select distinct a.HPTCODE as HLABNO, a.HLABNO as OID, a.HCOLCD as CLIENTCD, a.HPATNAM AS Patient_name, e.EPDFNAME as filepath from MLREGHDR a WITH (NOLOCK) left join MLPATMAS b WITH (NOLOCK) on a.HPTCODE = b.PTCODE left join MLREGDTL d WITH (NOLOCK) on a.HLABNO = d.DTLABNO left join MLREPORTEMAILPDF e WITH (NOLOCK) on a.HLABNO = e.ESID where a.HPATNAM NOT LIKE '%DUMMY%' and a.HFINDATE Is NOT NULL and a.HCOLCD in ('C0220','C0221','C0224','C0225') and a.HPTCODE <> '0' order by a.HPTCODE desc; END OK...!