C

@cheerasak777

BIG_SHACK_FOR_MYSQL

SQL
2 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
2 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
2 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
2 years ago
var LINE_ACCESS_TOKEN = "JUcAiDYEDrl7z88nr8mCaaqYwzVPSRNJb9OwPI+10gMRvUfIBcIEKLyMc2JS5BfNFVPwpyJ8txjus+KGh7pE4dtYbnJKhZ4bEd/4t1MqQGtg0MmU2RRlyXUI3aK6GhJMgU/9UH5bGJY7OcMBOG8bXQdB04t89/1O/w1cDnyilFU="; var ss = SpreadsheetApp.openByUrl("https://doc

BIG_FISH

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_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

CRM GEE structXXX

PHP
3 years ago
<!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>&#xE1A;&#xE31;&#xE19;&#xE17;&#xE36;&#xE01;&#xE0

SMALL-FISH @GEE

SQL
3 years ago
SELECT tbl_lab_setup_Test.Test_Code, tbl_lab_setup_Test.Test_Name, tbl_lab_setup_Test.Test_His_Code FROM dbo.tbl_lab_setup_Test_Profile INNER JOIN dbo.tbl_lab_setup_Test ON tbl_lab_setup_Test.Test_Code = tbl_lab_setup_Test_Profi

BIG_FISH_BY_GEE

SQL
3 years ago
SELECT lab_items_sub_group_list.lab_items_code, lab_items.lab_items_code, lab_items_sub_group_list.lab_items_sub_group_code, lab_items.lab_items_name, lab_items.ecode, lab_items.display_order, lab_items.lab_items_normal_value, lab_ite