SELECT

      LEFT(CONVERT(varchar,[ORDER DATETIME], 120),16) as 'Order time'
     ,LEFT(CONVERT(varchar,[REQ ITEM CHECKIN DATETIME], 120),16) as 'Receive Time'
     ,LEFT(CONVERT(varchar,[IREQ_LAST_APP_DT], 120),16) as 'Approve time'
     ,[HN]
     ,[LN]
     ,[FULLNAME] as [ชื่อ-สกุล]
     ,[YEAR] as ปี
     ,[SEX] as เพศ
     ,[WARD NAME] as จุดที่สั่ง
     ,[RES ITEM NAME] as Test
     ,CASE WHEN [RES ITEM NAME] = 'MCV' THEN 'CBC' ELSE 'Body Fluid Cell Count' END AS Test2
     ,[RES ITEM RESULT]  as [Result]  
  FROM [LAB_DB].[dbo].[view_lab_statistic_Result_List]

WHERE 
   [ORDER INACTIVE] ='N' 
     AND [RES ITEM REJECT] = 'N'
     AND [RES ITEM INACTIVE] = 'N'
     AND ([RES ITEM CODE] = 'HM015' OR [RES ITEM CODE] = 'MC050')
     AND [RES ITEM STATE] ='A'

/*
Search Date: [IREQ_LAST_APP_DT]

Search Date Text: Approve Time

Group By:

Having:

Order By:[IREQ_LAST_APP_DT]

*/