C

@cheerasak777

Ilink analytical html

Java
10 months ago
<!DOCTYPE html> <html> <head> <base target="_top"> <style> body { font-family: 'Kanit', sans-serif; padding: 20px; background-color: #f4f7fa; color: #333;

LINE::GEMINI BOT

Go
10 months ago
var channelToken = ""; //Token Line var apiKey = ""; //Key Gemini function replyMsg(replyToken, mess, channelToken) { var url = 'https://api.line.me/v2/bot/message/reply'; var opt = { 'headers': { 'Content-Type': 'application/json; charset=UTF-8', 'Authorization': 'Bearer ' + channelToken, },

Trigger [dbo].[CallIfSelectContact]

SQL
10 months ago
USE [LAB_DB] GO /****** Object: Trigger [dbo].[CallIfSelectContact] Script Date: 3/7/2568 17:09:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

Chromatic tuner

Python
10 months ago
<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Chromatic Tuner สำหรับกีตาร์</title> <style> * { box-sizing: border-box; margin: 0;

Chromatic tuner

Java
10 months ago
<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Chromatic Tuner สำหรับกีตาร์</title> <style> * { box-sizing: border-box; margin: 0;

interpret decclare_APRI_score_calc_@Index FLOAT

SQL
10 months ago
((%CH015% + 0.0) / (%CH1095% + 0.0) / (%HM014% + 0.0)) * 100 ------------------------------------------------------------------ DECLARE @Index FLOAT = (((%CH015% + 0.0) / (%CH1095% + 0.0) / (%HM014% + 0.0)) * 100) SELECT CASE WHEN @Index < 0.5 THEN "Non or Mild Fibrosis" WHEN @Index BETWEEN 0.5 AND 1.5 THEN "Significant Fibrosis" WHEN @Index > 1.5 THEN "Cirrhosis"

TRIGGER @critical contrax

Deno
11 months ago
USE [LAB_DB] GO /****** Object: Trigger [dbo].[CallIfSelectContact] Script Date: 3/7/2568 17:09:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

Ewhammy

Java
11 months ago
<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>เอฟเฟกต์เสียง Whammy กีตาร์</title> <!-- โหลด Tailwind CSS สำหรับการจัดสไตล์ --> <script src="https://cdn.tailwindcss.com"></script> <style> /* กำหนดฟอนต์ Inter สำหรับทั้งหน้า */

check Alert!! test in REACTIVE(X.XXX)

SQL
11 months ago
SELECT CASE WHEN "%IM054%" IS NULL THEN " " WHEN "%IM054%" = " " THEN " "

check Alert!! test in POSITIVE(X.XXX)

SQL
11 months ago
CASE WHEN "%IM054%" IS NULL THEN " " WHEN "%IM054%" = " " THEN " " WHEN

CorWBCs is RUNNING when NRBC not null

SQL
11 months ago
select CASE WHEN NULLIF(LTRIM(RTRIM(%HM020%)),"") IS NULL THEN NULL ELSE ("%HM003%" * 100) / ("%HM020%"+ 100) END

LABoratory with CASS Ex-1

SQL
11 months ago
-- 1. สร้างตารางตัวอย่างสำหรับผลการทดสอบ -- หากมีตารางอยู่แล้ว สามารถข้ามส่วนนี้ได้ CREATE TABLE LabTestResults ( ResultID INT PRIMARY KEY IDENTITY(1,1), PatientID INT NOT NULL, TestName VARCHAR(100) NOT NULL, RawResultValue DECIMAL(10, 2) NOT NULL, -- สมมติว่าเป็นค่าตัวเลขที่ได้จากการทดสอบ TestDateTime DATETIME DEFAULT GETDATE() );

BIG_SHACK_FOR_MYSQL

MySQL
1 year ago
SET @SubGroupCode = '106'; ---แทน'106'ด้วยเลข(lab_items_sub_group_code) SELECT sg_list.lab_items_sub_group_code AS SubGroupCode, sg.lab_items_sub_group_name AS SubGroupName, li.ecode AS ItemECode, li.lab_items_name AS ItemName, li.lab_items_code AS ItemCode, li.display_order AS DisplayOrder, li.lab_items_normal_value AS NormalValue,

Clear DB for newal

SQL
1 year ago
use lab_dbXXX declare @count int declare @max int declare @tsql nvarchar(255) declare @tbl table(rownum int IDENTITY (1, 1) Primary key NOT NULL , cmd nvarchar(255)) insert into @tbl(cmd) select ('delete ' + name) as cmd from sys.tables where name like 'tbl_lab_information%' or name ='tbl_lab_Analyzer_Result' select @max = COUNT(*) from @tbl

Statistics of the number of items ordered for inspectiสถิติการนับจำนวนรายการสั่งตรวจ มากกว่า 1 ครั้ง

SQL
1 year ago
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

NI_InstReg_GR5.exe " (Run as administrator)

SQL
1 year ago
(* if you don't have previous installation.) 1. Go to " Crack " Folder -> Run " NI_InstReg_GR5.exe " (Run as administrator) -> Click " Yes " 2. Go to " Setup " Folder -> Install : Guitar Rig 5 Setup PC.exe

ไม่ให้ได้คำตอบออกก่อนก่อนจะมีค่า when case A then B

SQL
1 year ago
SELECT case when (%CH264A% <> "") THEN ((%CH264A%*%CH266V%)/1000) ELSE 0 END

[ TRY_CAST ] เปลี่ยน mALB เป็นช่วง ถ้าตรวจสอบว่า "%CH050A%" ไม่ใช่ตัวเลข

SQL
1 year ago
CASE WHEN TRY_CAST("%CH050A%" AS FLOAT) IS NULL THEN "%CH050A%" ELSE CASE WHEN CAST("%CH050A%" AS FLOAT) < 30 THEN

IF T-LINE is EMPTY SET VALUE NULL

SQL
1 year ago
CASE WHEN "%CC0002%" ="Seen" AND "%TT0002%" ='' THEN '' WHEN "%CC0002%" ="Seen" AND "%TT0002%" ='SEEN' THEN 'POSITIVE' WHEN "%CC0002%" ="Seen" AND "%TT0002%" ='Non seen' THEN 'Negative' ELSE NULL END

TDR

Deno
1 year ago
OBR|17|185168148||^|N|||||99^88||||20250324164017|01-A-10||||||||||||||||||||||||||||||||| OBX|1|NM|Not<SP>available||0.000000||-||||F||0.000000|||RO24GW14SJL||  16:41:47.[685428] >> R: Barcode: 185168148 16:41:47.[687423] >> R: CollectTime: 24/3/2568 16:40:17 16:41:47.[689418] >> R: SentResultTime: 24/3/2568 16:40:22