SELECT LEFT(CONVERT(varchar,[REQ ITEM CHECKIN DATETIME], 120),16) as วันที่รับแล็บ ,LEFT(CONVERT(varchar,[ORDER DATETIME], 120),16) as วันที่สั่ง ,[HN] ,[LN] ,[FULLNAME] as [ชื่อ-สกุล] ,[YEAR] as ปี ,[SEX] as เพศ ,[WARD NAME] as จุดที่สั่ง ,[REQ ITEM GROUP CODE] as CODE ,[RES ITEM NAME] as รายการตรวจ ,[RES ITEM RESULT] as ผลการตรวจ ,[RES ITEM STATE] as state ,[ORDER COMMENT] as comment FROM [LAB_DB].[dbo].[view_lab_statistic_Result_List] WHERE [ORDER INACTIVE] ='n' AND ([REQ ITEM GROUP CODE] ='SP' or [REQ ITEM GROUP CODE] ='PA') AND ([REQ STATE] ='a' or [REQ STATE] ='u') --[REQ ITEM CHECKIN DATETIME] --Checkin
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter