@cheerasak777

CASE WHEN (%HM020% < 10) THEN NULL WHEN (%HM020% >=10) THEN (%HM003%*100) /(%HM020%+100) ELSE

select * from( SELECT i.[IREQ_PID] as HN ,i.[IRESI_LN] as LN ,r.IREQ_OD_NO as OrderNumber ,CONVERT(varchar, i.IREQ_LAST_CHK_DT, 25) as ReceiveDateTime ,r.IREQ_FULLNAME as Name ,i.[IRESI_RESULT] as [Specimen Type]

CASE WHEN "%CC0001%" = "Seen" THEN CASE WHEN "%TT0001%" IS NOT NULL AND "%TT0001%" = "SEEN" THEN "POSITIVE" WHEN "%TT0001%" IS NOT NULL AND "%TT0001%" = "Non seen" THEN "Negative" WHEN "%TT0001%" IS NOT NULL THEN "invalid" -- แสดงผล invalid เมื่อ TT0001 ทราบค่าแล้ว แต่ไม่ตรงกับเงื่อนไข ELSE

@echo off title Custom Shutdown REM Ask the user for input and convert minutes to seconds set /P minutes="Enter shutdown delay in minutes: " set /A seconds="%minutes%*60" REM Start windows' shutdown command echo Starting shutdown... shutdown -s -f -t %seconds%

CASE WHEN "%SP536%" = "<=10" AND "%CH129%" = "<=0.9" THEN "11.1" WHEN "%SP536%" = "<=10" AND "%CH129%" = "0.9" THEN "11.1" WHEN "%SP536%" = "<=10" AND "%CH129%" = "4.4" THEN "2.3" WHEN "%SP536%" = "<=10" AND "%CH129%" = "8.8" THEN "1.1" WHEN "%SP536%" = "<=10" AND "%CH129%" = "17.6" THEN "0.6" WHEN "%SP536%" = "<=10" AND "%CH129%" = "17.7" THEN "0.6" WHEN "%SP536%" = "<=10" AND "%CH129%" = ">=26.4" THEN "0.4" WHEN "%SP536%" = "<=10" AND "%CH129%" = ">

CASE WHEN "%SP536%" = "<=10" AND "%CH129%" = "<=0.9" THEN "11.1" WHEN "%SP536%" = "<=10" AND "%CH129%" = "0.9" THEN "11.1" WHEN "%SP536%" = "<=10" AND "%CH129%" = "4.4" THEN "2.3" WHEN "%SP536%" = "<=10" AND "%CH129%" = "8.8" THEN "1.1" WHEN "%SP536%" = "<=10" AND "%CH129%" = "17.6" THEN "0.6" WHEN "%SP536%" = "<=10" AND "%CH129%" = "17.7" THEN "0.6" WHEN "%SP536%" = "<=10" AND "%CH129%" = ">=26.4" THEN "0.4" WHEN "%SP536%" = "<=10" AND "%CH129%" = ">

SELECT t.ST400A, t.ST400B, CASE WHEN t.ST400A = @VisibleLine AND t.ST400B = @VisibleLine THEN @Positive ELSE @Invalid END AS Result FROM YourTableName AS t; -- ใช้ ALIAS ชื่อตารางเป็น t

https://barcodetopc.com/download/offline

select CASE WHEN {SEX} = "M" THEN ((140 - {AGEBIRTH}) * {WEIGHT}) / (72 * %CH003%) WHEN {SEX} = "F" THEN (((140 - {AGEBIRTH}) * {WEIGHT}) / (72 * %CH003%)) * 0.85 ELSE 0 END

@echo off taskkill /F /IM i-CN-HIS.exe /T D: cd D:\LIS\i-CN-HIS start i-CN-HIS.exe D: cd D:\LIS\RIAICN\i-CN-HIS start i-CN-HIS.exe

SELECT test_id, screening_method_1, screening_method_2, screening_method_3, confirmatory_result, CASE -- HIV Positive WHEN screening_method_1 = 'Positive' AND screening_method_2 = 'Positive'

<input type="text" id="searchInput" placeholder="ค้นหา..."> <script> function filterTable() { const input = document.getElementById("searchInput"); const filter = input.value.toUpperCase(); const table = document.querySelector("table"); const rows = table.getElementsByTagName("tr"); for (let i = 1; i < rows.length; i++) { // เริ่มจากแถวที่ 1 เพื่อข้ามหัวคอลัมน์ const cells = rows[i].getElementsByTagName("td");

@echo off title Custom Shutdown REM Ask the user for input and convert minutes to seconds set /P minutes="Enter shutdown delay in minutes: " set /A seconds="%minutes%*60" REM Start windows' shutdown command echo Starting shutdown... shutdown -s -f -t %seconds%

// ไฟล์ที่จะ Backup const srcGsId = "1Pit4bh5kCeFbY7o2acoZZuSmEh2X1Qqa_DpK5yWqR_I" // แก้ #1 // โฟลเดอร์ปลายทาง const dstFolderId = "1u_K1Ks__YyRMd5JGZZZfKvurpb-ODfpT" // แก้ #2 //==================================================== // // function backupGsFile() { const backupDateTime = Utilities.formatDate(new Date(), "GMT+7", "yyyy-MM-dd_HH-mm-ss")

case when ISNUMERIC("%SP350%")=0 THEN "%SP350%" else "" end ----"<>"----

<?xml version="1.0" encoding="utf-8"?> <object name="" type="TK0" assembly=""> <!-- Data section : Don't edit any attributes ! --> <properties> <property name="mappings" type="TK1" assembly=""> <items> <item name="0" type="TK2" assembly=""> <properties> <property name="liscode" type="TK3" assembly="">CM0040</property> <property name="lisname" type="TK3" assembly="">Glucose Challege Test</property>

select case when ISNUMERIC('%TEST%') = 1 then 'pass' else 'not' end

(%Serum Iron%/(%Serum Iron%+%UIBC%+0.0))*100

---not's PIVOT Select view_lab_statistic_Order_List.[HN] ,view_lab_statistic_Order_List.[FULLNAME] as Name ,[REQ ITEM NAME] as Test ,Count(LN) as Count From view_lab_statistic_Order_List join view_lab_information_Request_Items_Specimen on view_lab_information_Request_Items_Specimen.[IREQI_LN] = view_lab_statistic_Order_List.[LN] and view_lab_information_Request_Items_Specimen.IREQI_CODE = view_lab_statistic_Order_List.[REQ ITEM CODE] Where ([order inactive]<>'Y')

Sub CopyDataByColumnName() Dim wsSource As Worksheet Dim wsDestination As Worksheet Dim colSource As Range, colDest As Range Set wsSource = ThisWorkbook.Sheets("items") Set wsDestination = ThisWorkbook.Sheets("tbl_lab_setup_Test") ' หาคอลัมน์ที่ต้องการคัดลอกในแต่ละชีต Set colSource = wsSource.Columns("AX")