C

@cheerasak777

estimate CrCl

SQL
2 years ago
select CASE WHEN {SEX} = "M" THEN ((140 - {AGEBIRTH}) * {WEIGHT}) / (72 * %CH003%) WHEN {SEX} = "F" THEN (((140 - {AGEBIRTH}) * {WEIGHT}) / (72 * %CH003%)) * 0.85 ELSE 0 END

UPDATE Test_Blank_Result_Flag = 1แก้ไขให้โปรไฟล์นับเป็นสถิติด้วย

SQL
2 years ago
USE LAB_DB UPDATE dbo.tbl_lab_setup_Test_Control SET Test_Blank_Result_Flag = 1 WHERE Test_Code IN ( SELECT Test_Code FROM

UPDATE_CREAROR_For_NEW

SQL
2 years ago
use -------------- MTP_LAB_DB 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.

Update TAT(R) and TAT (S)

SQL
2 years ago
UPDATE tbl_lab_setup_Test_Control SET dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Days = '0', ---DATE dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Hours = '2', ---Hr dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Minutes = '0' ---Min WHERE

LN แยกLN:66###-01

SQL
3 years ago
mid({BarcodeInfo.LN},1,8) + "-" + mid({BarcodeInfo.LN},9,2) /* ตัวอย่างการใช้งาน: // กำหนดตัวแปร BarcodeInfo.LN var BarcodeInfo = { LN: "1234567890" };

LN แยกLN:66###-01

SQL
3 years ago
mid({BarcodeInfo.LN},1,8) + "-" + mid({BarcodeInfo.LN},9,2) /* ตัวอย่างการใช้งาน: // กำหนดตัวแปร BarcodeInfo.LN var BarcodeInfo = { LN: "1234567890" };

A:C BY BOSS PEE NOONG(UACR)

SQL
3 years ago
CASE WHEN "%CH201%" = "<10" AND "%CH202%" = "<10" THEN "<30" WHEN "%CH201%" = "<10" AND "%CH202%" <> "" THEN "<30" WHEN "%CH201%" = "10" AND "%CH202%" = "<10" THEN "50" WHEN "%CH201%" = "10" AND "%CH202%" = "10" THEN "100" WHEN "

MAU is ### (NORMAL/ABNOR)

SQL
3 years ago
CASE WHEN( (%CC0570%* 100)/%CC5751% ) < 30 THEN "Normal (Less than 30 mg/g)" WHEN ( (%CC0570%* 100)/%CC5751% ) >= 30 AND %CC5752% < 300 THEN "Abnormal (Between 30-300 mg/g)" WHEN ( (%CC0570%* 100)/%CC5751%

kill i-CN HIS

Bash
3 years ago
taskkill /F /IM I-CN-HIS.exe /T c: cd C:\Program Files (x86)\i-CN-HIS HL7 start i-CN-HIS.exe timeout 1

นับจำนวน HNต่อวัน

SQL
3 years ago
select HN from( SELECT convert(varchar(10), [IREQ_OD_DT], 120) as OrderDate ,[IREQ_PID] as HN FROM [view_lab_information_Request] where IREQ_INACTIVE = 'N' and IREQ_OD_DT between '@d1' and '@d2' ) as x group by OrderDate, HN

Find duplicates of HisCode.

SQL
3 years ago
SELECT Test_His_Code , COUNT(*) count FROM tbl_lab_setup_Test GROUP BY [Test_His_Code] Having COUNT(*) > 1

GEE@botLine@BardTHAI

Java
3 years ago
//เด็กคอม www.dek-com.com const ACCESS_TOKEN = "ACCESS_TOKEN"; const bot = new LineBotSdk.client(ACCESS_TOKEN); function doPost(e) { bot.call(e, callback) }; function callback(e) { if (e.message.type == "text" ) { bot.replyMessage(e, [bot.te

BIG_SHACK_FOR_MYSQL

SQL
3 years ago
SET @SubGroupCode = '106'; --1068คือ subGroupCode (SET @ใช้กับMYSQL]) 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

อัพเดท UPDATE Source_Definition

SQL
3 years ago
/*UPDATE dbo.tbl_lab_setup_Source_Definition SET Source_Definition_Name = CASE WHEN Source_Definition_Code = '000' THEN 'ไม่ทราบฝ่าย' WHEN Source_Definition_Code = '001' THEN 'ความดัน' -- เพิ่มเงื่อนไขสำหรับ Source_Definition_Code อื่น ๆ

function doPost(e)

Java
3 years ago
function doPost(e) { var ssId = "<Your Google Sheet ID>"; var ss = SpreadsheetApp.openById(ssId); var sheetData1 = ss.getSheetByName("data1"); var sheetData2 = ss.getSheetByName("data2"); //use BetterLog Logger = BetterLog.useSpr

GEE@BOT

Java
3 years ago
var LINE_ACCESS_TOKEN = "JUcAiDYEDrl7z88nr8mCaaqYwzVPSRNJb9OwPI+10gMRvUfIBcIEKLyMc2JS5BfNFVPwpyJ8txjus+KGh7pE4dtYbnJKhZ4bEd/4t1MqQGtg0MmU2RRlyXUI3aK6GhJMgU/9UH5bGJY7OcMBOG8bXQdB04t89/1O/w1cDnyilFU="; var ss = SpreadsheetApp.openByUrl("https://doc

BIG_FISH

SQL
3 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_valu

(Result) CD4 res.list

SQL
3 years ago
SELECT tbl_lab_information_Patient.IPT_TITLE + ' ' + tbl_lab_information_Patient.IPT_FNAME + ' ' + tbl_lab_information_Patient.IPT_LNAME AS 'ชื่อ' ,[YEAR] as 'อายุ' ,[HN] as 'HN' ,[PATIENT TYPE NAME] as 'สิทธิการรักษา' ,(SELECT CAST(DATEPART

นับจำนวนคนไข้ตามHN

SQL
3 years ago
select HN from( SELECT convert(varchar(10), [IREQ_OD_DT], 120) as OrderDate ,[IREQ_PID] as HN FROM [view_lab_information_Request] where IREQ_INACTIVE = 'N' and IREQ_OD_DT between '@d1' and '@d2' ) as x group by OrderDate, HN ---

Hide GroupsName Section LNTH

SQL
3 years ago
// Hide GroupsName Section LNTH // (C) JaeKunGz 22-12-65 16.12 // Hide For Show Biochemistry Label // Group Hide stringVar array SectionHide := ['ANC','Blood Bank','Bacteria C/S','Bodyfluid Exam','Genetics','Hemotology','Immunology','Microbio