SELECT * FROM  PACS.DICOMSERVER.dbo.PEIS_PacsResult 
WHERE PatientCode in
(
'70996','70995','71013','71015','71009','70996','54515','54521','71008'
)


SELECT * FROM  PACS.DICOMSERVER.dbo.PEIS_PacsResult WHERE PatientCode ='80000'