@cheerasak777

-- 1. ตั้งค่าตัวแปร (Configuration) DECLARE @TargetDays INT = 90; DECLARE @StartDate DATETIME = '2024-10-01 00:00:00'; DECLARE @EndDate DATETIME = '2025-09-30 23:59:59'; -- 2. กำหนดรายการรหัสเทสที่ต้องการวัดผล DECLARE @Test_code TABLE (ItemCode VARCHAR(50)); INSERT INTO @Test_code VALUES ('SR065'), ('SRT079'); -- 3. ส่วนการคำนวณ Logic

WITH DuplicateTests AS ( SELECT v.[HN], v.[FULLNAME] AS Name, v.[REQ ITEM NAME] AS TestName, v.[LN], v.[REQ ITEM ORDER DATETIME] AS OrderDate, COUNT(*) OVER (PARTITION BY v.[HN], v.[REQ ITEM CODE]) AS TestCount FROM view_lab_statistic_Order_List v JOIN view_lab_information_Request_Items_Specimen i

SELECT o.[HN], o.[FULLNAME] AS Name, o.[REQ ITEM NAME] AS Test FROM view_lab_statistic_Order_List AS o JOIN tbl_lab_setup_Test_Control AS c ON o.[REQ ITEM CODE] = c.Test_Code WHERE o.[order inactive] <> 'Y' AND o.[req item state] <> 'R' AND c.Test_Limit_Order_Flag = 1

SELECT [dbo].[tbl_lab_information_Request].[IREQ_PID] AS _col_1, [dbo].[tbl_lab_information_Result_Items].[IRESI_LN] AS _col_2, [dbo].[tbl_lab_information_Result_Items].[IRESI_STATE] AS _col_3, count_big( * ) AS _col_4 FROM [dbo].[tbl_lab_information_Request], [dbo].[tbl_lab_information_Request_Items], [dbo].[tbl_lab_information_Result_Items], [dbo].[tbl_lab_setup_Test]

BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here Declare @LN varchar(20) SELECT @LN = i.LN FROM inserted AS i Declare @TestCode varchar(6) SELECT @TestCode = i.Test_Code FROM inserted AS i

<?xml version="1.0" encoding="utf-8"?> <object name="" type="TK0" assembly=""> <!-- Data section : Don't edit any attributes ! --> <properties> <property name="Encoder" type="TK1" assembly="">utf-8</property> <property name="SerumIndexEnabled" type="TK2" assembly="">False</property> <property name="AutoAddLISOrder" type="TK2" assembly="">True</property> <property name="AutoAddLISOrderList" type="TK3" assembly=""> <items> <item name="0" type="TK1" assembly="">L<

SELECT v.[HN], v.[FULLNAME] AS PatientName, r.[REQ ITEM NAME] AS LabTest, v.[REQ ITEM ORDER DATETIME] AS OrderDate, COUNT(v.[LN]) AS TestCount FROM view_lab_statistic_Order_List v JOIN view_lab_information_Request_Items_Specimen r

; กด F8 เพื่อเริ่มการทำงาน F8:: { try { ; เชื่อมต่อกับ Excel ที่เปิดค้างไว้ xl := ComObjectActive("Excel.Application") } catch { MsgBox "กรุณาเปิดไฟล์ Excel ก่อนเริ่มใช้งานเด้อครับ", "บ่พ้อไฟล์" return }

-- กลุ่มที่ 33 SELECT sub.lab_items_sub_group_code AS group_id, item.lab_items_name, item.display_order FROM lab_items_sub_group_list sub INNER JOIN lab_items item ON item.lab_items_code = sub.lab_items_code WHERE sub.lab_items_sub_group_code = '33' UNION ALL -- กลุ่มที่ 43 SELECT sub.lab_items_sub_group_code AS group_id, item.lab_items_name, item.display_order

// Google Apps Script สำหรับบันทึกเวลาเข้า-ออกงานและส่งอีเมล // ตั้งค่าเริ่มต้น const CONFIG = { spreadsheetId: 'YOUR_SPREADSHEET_ID', // ID ของ Google Sheets สำหรับเก็บข้อมูล sheetName: 'AttendanceRecords', // ชื่อชีตสำหรับเก็บข้อมูล folderId: 'YOUR_FOLDER_ID', // ID ของ Google Drive Folder สำหรับเก็บรูปภาพ adminEmail: 'admin@company.com', // อีเมลแอดมิน emailSubject: 'ยืนยันการบันทึกเวลาเข้า-ออกงาน', dateFormat: 'dd/MM/yyyy',

SELECT * FROM dbo.view_lab_statistic_Order_List AS v WHERE v.[REQ ITEM CODE] IN ('SR065', 'SRT079') AND v.[REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000' AND '2025-09-30 00:00:00.000' AND v.[HN] IN ( SELECT [HN] FROM dbo.view_lab_statistic_Order_List WHERE [REQ ITEM CODE] IN ('SR065', 'SRT079') AND [REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000'

CASE -- Group O: Anti-A Neg, Anti-B Neg, Anti-AB Neg, A cell Pos, B cell Pos WHEN "%BB007A%" = "Negative" AND "%BB007B%" = "Negative" AND "%BB007C%" = "Negative" AND "%Acell%" LIKE "%Positive%" AND "%Bcell%" LIKE "%Positive%" THEN "O" -- Group A: Anti-A Pos, Anti-B Neg, Anti-AB Pos, A cell Neg, B cell Pos

@echo off set SOURCE=C:\Users\reall\Documents\Work set TEMP=C:\Users\reall\Documents\TempBackup set DEST=D:\WorkBackup if not exist "%TEMP%" mkdir "%TEMP%" if not exist "%DEST%" for /f "tokens=1-4 delims=/ " %%a in ('date /t') do set dt=%%d-%%b-%%c set ZIPFILE=%TEMP%\WorkBackup_%dt%.zip

CASE -- กรณี Creatinine < 10 WHEN U_CREA < 10 AND U_ALB < 10 THEN 'Re-Collect' WHEN U_CREA < 10 AND U_ALB = 10 THEN 'Re-Collect' WHEN U_CREA < 10 AND U_ALB >= 30 THEN 'N/A' -- กรณี Creatinine = 10 WHEN U_CREA = 10 AND U_ALB < 10 THEN 'Re-Collect' WHEN U_CREA = 10 AND U_ALB = 10 THEN 'Re-Collect' WHEN U_CREA = 10 AND U_ALB = 30 THEN 300

CASE -- ถ้าแถบควบคุมไม่ขึ้น (C ไม่ใช่ 'Seen') ให้ถือว่าผลไม่ถูกต้อง WHEN CC0008 <> 'Seen' THEN 'Invalid' -- แถบควบคุมขึ้น แต่ทั้ง IgM และ IgG ไม่ขึ้น → ผลลบ WHEN CC0008 = 'Seen' AND TT0008 = 'Non seen' AND TT0018 = 'Non seen' THEN 'Negative'

SELECT CASE WHEN rc > 0 AND nc = 0 THEN 'Positive' WHEN nc > 0 AND rc = 0 THEN 'Negative' ELSE 'Inconclusive' END AS result_status FROM ( SELECT IM0951 AS c1, IM0952 AS c2,

Use the nano-banana model to create a 1/7 scale commercialized figure of the character in the illustration, in a realistic style and environment. Place the figure on a computer desk, using a circular transparent acrylic base without any text. On the computer screen, display the ZBrush modeling process of the figure. Next to the computer screen, place a BANDAl-style toy packaging box printed with the original artwork."

<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>เครื่องตั้งสายกีตาร์แบบ Chromatic</title> <style> * { box-sizing: border-box; margin: 0;

<!DOCTYPE html> <html lang="th_TH"> <head> <meta charset="utf-8" UICulture="th" Culture="th-TH" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <title>บันทึกการรับแจ้งงาน LIS - ระบบ CRM </title> <link href="/favicon.ico" rel="shortcut icon" type="image/x-icon" /> <link rel="stylesheet" href="/css/site.css" /> <link href="/css/sb-admin-2.css" rel="stylesheet" />

function doGet() { return HtmlService.createHtmlOutputFromFile('index') .setTitle('i-Link LIS Mind Map') .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); }