Project

General

Profile

Bug #227 » query sebelum diubah.txt

Muhammad Bintar, 03/16/2021 03:21 PM

 
1
/*DECLARE @EmployeeID VARCHAR(8) = '10000032' DECLARE @TreatmentType VARCHAR(8) = '02' DECLARE @MedicalFamily VARCHAR(8) = ''*/ IF @MedicalFamily = '' BEGIN SET @MedicalFamily = '0001' END SELECT  HeaderSequence , Sequence , Plafond , MedicalFamily FROM    dbo.PHRPA0041 WHERE   EmployeeID = @EmployeeID AND TreatmentType = @TreatmentType AND MedicalFamily = @MedicalFamily
(6-6/7)