C

@cheerasak777

**INSERT TABLE OF LIS

MySQL
1 year ago
use ---lab_db Select * From tbl_lab_setup_Test Where Test_Code='SP0000' go Insert Into tbl_lab_setup_Test ( Test_Code ,

EVEN:INSERT@SP000 แบบshorttext

SQL
2 years ago
Select * From tbl_lab_setup_Test Where Test_Code='SP0000' go Insert Into tbl_lab_setup_Test(Test_Code,Test_Group_Code,Test_Seq,Test_Name,Test_Display_Name,Test_Display_Name_Hide_Print_Flag,Test_Type_Code,Test_Order_Status_Flag,Test_Data_Type_Code,Sp

EVEN:INSERT@SP000 แบบshorttext

SQL
2 years ago
Select * From tbl_lab_setup_Test Where Test_Code='SP0000' go Insert Into tbl_lab_setup_Test(Test_Code,Test_Group_Code,Test_Seq,Test_Name,Test_Display_Name,Test_Display_Name_Hide_Print_Flag,Test_Type_Code,Test_Order_Status_Flag,Test_Data_Type_Code,Sp

EVEN:INSERT@SP000 แบบshorttext

SQL
2 years ago
Select * From tbl_lab_setup_Test Where Test_Code='SP0000' go Insert Into tbl_lab_setup_Test(Test_Code,Test_Group_Code,Test_Seq,Test_Name,Test_Display_Name,Test_Display_Name_Hide_Print_Flag,Test_Type_Code,Test_Order_Status_Flag,Test_Data_Type_Code,Sp

MASTER EU5300 log

Assembly
2 years ago
OBX|1|IS|08001^Take Mode^99MRC||A||||||F OBX|2|IS|08002^Blood Mode^99MRC||P||||||F OBX|3|IS|08003^Test Mode^99MRC||CHEM+SEDIM||||||F OBX|4|IS|01002^Ref Group^99MRC||Man||||||F OBX|5|NM|30525-0^Age^LN||48|yr|||||F OBX|6|IS|05007^Project Type^99MRC||

RES_LIST pivot CUSTOM REPORT

SQL
2 years ago
SELECT * FROM ( SELECT LEFT(CONVERT(varchar, [ORDER DATETIME], 120), 16) as [Order D /T] , LEFT(CONVERT(varchar, [REQ ITEM CHECKIN DATETIME], 120), 16) as [Receive D/T] , LEFT(CONVERT(varchar, [RES ITEM APPROVE

RES.LIST(CBC,BODY_FLUID)

SQL
2 years ago
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]

HIV3SANGKA

MySQL
2 years ago
CASE WHEN @HIV1 = 'Non-reactive' AND @HIV2 = 'Non-reactive' AND @HIV3 = 'Non-reactive' THEN 'Negative' WHEN @HIV1 = 'Reactive' AND @HIV2 = 'Reactive' AND @HIV3 = 'Reactive' THEN 'Positive' WHEN (@HIV1 = 'Reactive' OR @HIV2 =

Web link representation for the “I-Link User Manual

Java
2 years ago
Here is a web link representation for the “I-Link User Manual” based on the provided PDF: <!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>คู่มื

Values to use with an "IN" query

SQL
2 years ago
SELECT GROUP_CONCAT( CONCATENATE(id, ', ', description) ) AS results FROM data; -- /* This utility will convert: Values to use with an "IN" query

WBC Corrected MORE THAN 10 NULL

SQL
2 years ago
select CASE WHEN(%HM020% >=10) THEN (%HM003%*100)/(%HM020%+100) ELSE NULL END

tim3

PHP
2 years ago
https://dayspedia.com/time/online/

time onlin

Go
2 years ago
https://dayspedia.com/time/online/

eGFR+ (STAGE)

SQL
2 years ago
declare @value decimal(10,2) set @value = (select CASE WHEN %CH003% = 0 THEN 0 WHEN {AGE,YEAR} > 130.0 THEN 0 WHEN {AGE,YEAR} < 18.0 THEN ((0.41 * {HEIGHT}) / %CH003%) WHEN {SEX} = "M" AND %CH003% <= 0.9 THEN ((141 * (POWER((%CH003% / 0.9), -0.4

BIG_FISH-III_BY_GEE

SQL
2 years ago
SELECT lab_items_sub_group_list.lab_items_sub_group_code, lab_items_sub_group.lab_items_sub_group_name, lab_items.ecode, lab_items.lab_items_name, lab_items.lab_items_code, lab_items.display_order, lab_items.lab_items_normal_value, la

SHORT_CUT_TV

SQL
2 years ago
"C:\Program Files (x86)\TeamViewer\TeamViewer.exe" -i 192.168.0.22 -P 123456 /* TEAMV Re-direct to Client */

GET ANACODE ONLY

Python
2 years ago
import re # Define the HL7 message hl7_message = """ R: <VT>MSH|^~\&|LabXpert|Mindray|||20240326132228||ORU^R01|1|P|2.3.1||||||UNICODE<CR>PID|1||^^^^MR<CR>PV1|1<CR>OBR|1||001|00001^Automated Count^99MRC|||20240326132224|||||||||||||||||HM|NotValida

Req_list_statistic_by_aot

SQL
2 years ago
—-Req_list_statistic_by_aot Select [HN], [LN], [FULLNAME], [YEAR], [SEX], [WARD NAME], [SOURCE NAME], [PRIORITY],

mod-Small-fish alias

SQL
2 years ago
SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code FROM dbo.tbl_lab_setup_Test_Profile tltp INNER JOIN dbo.tbl_lab_setup_Test tlt ON tltp.Test_Item_Code = tlt.Test_Code WHERE tltp.Test_Profile_Code IN ('CH046','CH046A','CH046V') ORDER BY Test

VET@CHL

SQL
2 years ago
[SCO13 -HIGLUCOSE, GLU [SCO14)-[BUNJ-[BUN] [SCO15)-[CREATININE]-[CREA] [SC008-[SGOT (AST))-[AST] [SCO091-ISPT (ALT)-[ALT] [SCO10)-(ALK PHOS)-[ALP] [SCO16)-[PROTEIN-(TP) [SC017)-[ALBUMIN)-[ALB] [SC0111-[CHOLESTEROLI-(TC] [SC012)-(TRIGLYCERIDE]-(TG] [