Project

General

Profile

Feature #3434 » PDSFILOPRODGENLOT_20250313.sql

Tri Rizqiaty, 03/13/2025 03:28 PM

 
1
??
2

3
ALTER PROCEDURE [dbo].[PDSFILOPRODGENLOT]
4

5
(
6

7
	 @ProductionCode VARCHAR(50),
8

9
	 @MachineNumber VARCHAR(100),
10

11
	 @Shift VARCHAR(100),
12

13
	 @DocDate VARCHAR(50)
14

15
)
16

17
AS
18

19

20

21
--DECLARE @ProductionCode VARCHAR(50) = 'C'
22

23
--DECLARE @MachineNumber VARCHAR(100) = '02'
24

25
--DECLARE @Shift VARCHAR(100) = '3'
26

27
--DECLARE @DocDate VARCHAR(50) = '20250109'
28

29

30

31
DECLARE @Lot VARCHAR(100)
32

33

34

35
SET @Lot = @ProductionCode + RIGHT(@DocDate,2) + SUBSTRING(@DocDate,5,2) + SUBSTRING(@DocDate, 4,1) + @Shift + @MachineNumber
36

37

38

39
SELECT @Lot AS Lot
(3-3/5)