C

@cheerasak777

EVEN:INSERT@SP000 แบบshorttext

SQL
1 year 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,Specimen_Type_Code,Test_His_Code,Test_Checkup_Code,Test_Send_Out_Flag,Test_Preliminary_Enable_Flag,Test_Inactive,Test_Method_Code,Test_Profile_Option_Flag,Test_Checkup_Flag,Test_Profile_Option_Share_Code_Flag) Values('SP0000','OL','',N'SPECIAL TEST',N'

EVEN:INSERT@SP000 แบบshorttext

SQL
1 year 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,Specimen_Type_Code,Test_His_Code,Test_Checkup_Code,Test_Send_Out_Flag,Test_Preliminary_Enable_Flag,Test_Inactive,Test_Method_Code,Test_Profile_Option_Flag,Test_Checkup_Flag,Test_Profile_Option_Share_Code_Flag) Values('SP0000','OL','',N'SPECIAL TEST',N'

MASTER EU5300 log

Assembly
1 year 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||UR||||||F OBX|7|ST|01012^Shelf No^99MRC||2||||||F OBX|8|ST|01013^Tube No^99MRC||3||||||F OBX|9|ST|09001^Analyzer^99MRC||EU-5300 Pro-1||||||F

RES_LIST pivot CUSTOM REPORT

SQL
1 year 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 DATETIME], 120), 16) as [Approve D/T] , LN as 'LAB NO.' , [HN] as 'PID' , [REF ID]

RES.LIST(CBC,BODY_FLUID)

SQL
1 year 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] ,[LN] ,[FULLNAME] as [ชื่อ-สกุล] ,[YEAR] as ปี ,[SEX] as เพศ

HIV3SANGKA

MySQL
1 year 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 = 'Reactive' OR @HIV3 = 'Reactive') AND (@HIV1 = 'Non-reactive' OR @HIV2 = 'Non-reactive' OR @HIV3 = 'Non-reactive' OR @HIV1 IS NULL OR @HIV2 IS NULL OR @HIV3 IS NULL) THEN 'Inconclusive' ELSE 'Unknown' EN

Web link representation for the “I-Link User Manual

Java
1 year 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>คู่มือการใช้งานระบบ I-Link</title> <style> body {

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.411))) * POWER(0.993, {AGE,YEAR})) WHEN {SEX} = "M" AND %CH003% > 0.9 THEN ((141 * (POWER((%CH003% / 0.9), -1.209))) * POWER(0.993, {AGE,YEAR})) WHEN {SEX} = "F" AND %CH003% <= 0.7 THEN ((144 * (POWER((%CH003% / 0.7), -0.329))) * POWER(0.993, {AGE,Y

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, lab_items.possible_value, lab_items.lab_items_unit

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|NotValidated|||||||service<CR>OBX|1|IS|08003^Test Mode^99MRC||CHEM+SEDIM||||||F<CR>OBX|2|IS|05007^Project Type^99MRC||UR||||||F<CR>OBX|3|NM|16601^URO^99MRC||norm.|||N|||F<CR>OBX|4|NM|16604^BIL^99MRC||-|||N|||F<CR>OBX|5|NM|16608^KET^99MRC||-|||N|||F<CR>OBX|6|N

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_Profile_Code ASC /* SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code , tlt.Test_Checkup_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

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] [SCO19)-[BILIRUBIN (TOTAL) -[

ตามหาลูก #BIG_FISH_Test_#SELECT:His_Code ,Test_Checkup_Code

SQL
2 years ago
SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code ,Test_Checkup_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 ('MC050P','MC050P','MC044P','MC047P')

UA WTNNK

TypeScript
2 years ago
<?xml version="1.0" encoding="windows-874"?> <HOSXP2LIS> <Header> <Sender>LIS</Sender> <Receiver>HOSxP</Receiver> <Pattern>P</Pattern> <GenerateDate>2024-03-05</GenerateDate> <GenerateTime>14:32:05</GenerateTime> </Header> <Patient>