@cheerasak777

// ไฟล์ที่จะ Backup const srcGsId = "1Pit4bh5kCeFbY7o2acoZZuSmEh2X1Qqa_DpK5yWqR_I" // แก้ #1 // โฟลเดอร์ปลายทาง const dstFolderId = "1u_K1Ks__YyRMd5JGZZZfKvurpb-ODfpT" // แก้ #2 //==================================================== // //

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"

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_

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

USE [LAB_DB_GTR] GO /****** Object: Table [dbo].[lab_item] Script Date: 22/10/2567 4:36:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[lab_item]( [lab_items_code] [nvarchar](50) NULL, [lab_items_name] [nvarchar

Sub InsertDataToSQLServer() Dim conn As Object Dim cmd As Object Dim ws As Worksheet Dim lastRow As Long Dim i As Long Dim labItemCode As String Dim testType As String Dim resultType As String

DECLARE @Test_Profile_Code VARCHAR(10) SET @Test_Profile_Code = 'MC0001' SELECT t.Test_Code, t.Test_Name, t.Test_His_Code, t.Test_Checkup_Code FROM dbo.tbl_lab_setup_Test t INNER JOIN dbo.tbl_lab_setup_Test_Profile tp ON t.Test_Code = tp.Test_Item

select case when "%CM0034%" = "<30" then "Negative" when ISNUMERIC("%CM0034%") = 1 then case when

\^(.+?)\^ /\^(.+?)\^99MRC/gm

case when "%testcode%" = "<30" then "Negative" when ISNUMERIC("%testcode%") = 1 then case when CONVERT(float,"%testcode%") between 30.0 and 300.0 then "Trace" else "N/A" end when "%testcode%" = ">3000" then "Positive" else "N/A" end

select CASE WHEN "%IM165%" = "> 1000.00" THEN "Positive" WHEN CAST(REPLACE("%IM165%","> ", "") as float) >= 0.00 AND CAST(REPLACE("%IM165%","> ", "") as float) < 10.00 THEN "Negative" WHEN CAST(REPLACE("%IM165%","> ", "") as float) >= 10.00 THEN "

select CASE WHEN "%IM165%" = "> 1000.00" THEN "Positive" WHEN CAST(REPLACE("%IM165%","> ", "") as float) >= 0.00 AND CAST(REPLACE("%IM165%","> ", "") as float) < 10.00 THEN "Negative" WHEN CAST(REPLACE("%IM165%","> ", "") as float) >= 10.00 THEN "

select CASE WHEN "%IM165%" = "> 1000.00" THEN "Positive" WHEN CAST(REPLACE("%IM165%","> ", "") as float) >= 0.00 AND CAST(REPLACE("%IM165%","> ", "") as float) < 10.00 THEN "Negative" WHEN CAST(REPLACE("%IM165%","> ", "") as float) >= 10.00 THEN "

SELECT tp.Test_Item_Code AS 'รหัสรายการเทสในโปรไฟล์', tp.Test_Profile_Code AS 'รหัสโปรไฟล์', t.Test_Name AS 'ชื่อเทส', t.Test_His_Code AS 'รหัสเทสในระบบ HIS' FROM dbo.tbl_lab_setup_Test_Profile tp INNER JOIN dbo.tbl_lab_setup_Test t ON

select case when LEFT("%IM297%" , 1) = "<" then "Non reactive" WHEN CAST("%IM297%" AS decimal) < 0.0 THEN "Non reactive" WHEN CAST("%IM297%" AS decimal) < 10.0 THEN "Non reactive" WHEN CAST("%IM297%" AS decimal) >= 10.0 THEN "Reactive" else

SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME = 'YourTableName'

---SMallfish ATLIAS version SELECT lisg.lab_items_sub_group_code, lisg.lab_items_sub_group_name, li.ecode, li.lab_items_name, li.lab_items_code, li.display_order, li.lab_items_normal_value, li.possibl