2020-03-11

SP76

• 95218-P4202C和P4202C相隔要大於161天, 要往前月份判斷
  ---住診XML
  SELECT p3,* FROM INPDHead DH
  INNER JOIN INPDBody DB ON DH.DId = DB.DId
  INNER JOIN INPPData PD ON DB.DId = PD.DId
  WHERE 1=1 and p3='P4202C'
  
  ---門診XML
  SELECT top 100 d28,* FROM OPDDHead DH
  INNER JOIN OPDDBody DB ON DH.DId = DB.DId
  INNER JOIN OPDPData PD ON DB.DId = PD.DId
  WHERE 1=1 and p4 in ('P4202C')
  
• 94150-申報轉媒體-轉XML功能失效