Bug #227 » query sebelum diubah.txt
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 |
---|