608
« เมื่อ: พฤษภาคม 29, 2009, 13:18:07 PM »
ผมลองไปใช้ custom search แล้วใส่รหัส icd ตามที่ต้องการ เลือกช่วงเวลาประมวลผลเสร็จไป COPY command จาก SQL มาทำข้อมูลใช้ได้ลองดูนะครับท่านอาจารย์
select pt.*,ov.*
from vn_stat ov ,patient pt ,ovst ovst
where ov.vn=ovst.vn and pt.hn=ov.hn and ov.vstdate between "2009-05-28" and "2009-05-28" and ov.hn=pt.hn
and ov.age_y>= 0
and ov.age_y<= 200
and ovst.main_dep="011"
and ( (ov.pdx like "J029%")
or (ov.dx0 like "J029%")
or (ov.dx1 like "J029%")
or (ov.dx2 like "J029%")
or (ov.dx3 like "J029%")
or (ov.dx4 like "J029%")
or (ov.dx5 like "J029%")
or (ov.pdx like "J069%")
or (ov.dx0 like "J069%")
or (ov.dx1 like "J069%")
or (ov.dx2 like "J069%")
or (ov.dx3 like "J069%")
or (ov.dx4 like "J069%")
or (ov.dx5 like "J069%")
or (ov.pdx like "J00%")
or (ov.dx0 like "J00%")
or (ov.dx1 like "J00%")
or (ov.dx2 like "J00%")
or (ov.dx3 like "J00%")
or (ov.dx4 like "J00%")
or (ov.dx5 like "J00%")
or (ov.pdx like "J100%")
or (ov.dx0 like "J100%")
or (ov.dx1 like "J100%")
or (ov.dx2 like "J100%")
or (ov.dx3 like "J100%")
or (ov.dx4 like "J100%")
or (ov.dx5 like "J100%")
or (ov.pdx like "J101%")
or (ov.dx0 like "J101%")
or (ov.dx1 like "J101%")
or (ov.dx2 like "J101%")
or (ov.dx3 like "J101%")
or (ov.dx4 like "J101%")
or (ov.dx5 like "J101%")
or (ov.pdx like "J108%")
or (ov.dx0 like "J108%")
or (ov.dx1 like "J108%")
or (ov.dx2 like "J108%")
or (ov.dx3 like "J108%")
or (ov.dx4 like "J108%")
or (ov.dx5 like "J108%")
or (ov.pdx like "J110%")
or (ov.dx0 like "J110%")
or (ov.dx1 like "J110%")
or (ov.dx2 like "J110%")
or (ov.dx3 like "J110%")
or (ov.dx4 like "J110%")
or (ov.dx5 like "J110%")
or (ov.pdx like "J111%")
or (ov.dx0 like "J111%")
or (ov.dx1 like "J111%")
or (ov.dx2 like "J111%")
or (ov.dx3 like "J111%")
or (ov.dx4 like "J111%")
or (ov.dx5 like "J111%")
or (ov.pdx like "J118%")
or (ov.dx0 like "J118%")
or (ov.dx1 like "J118%")
or (ov.dx2 like "J118%")
or (ov.dx3 like "J118%")
or (ov.dx4 like "J118%")
or (ov.dx5 like "J118%")
)
********main_dep="011" คือ จุดบริการ ER ถ้าต้องการ OPD ก็ตัด บรรทัดนั้นทิ้งลองดูครับ