KJL

??ALTER PROCEDURE [dbo].[PDSFILOPRODGENLOT]

(

	 @ProductionCode VARCHAR(50),

	 @MachineNumber VARCHAR(100),

	 @Shift VARCHAR(100),

	 @DocDate VARCHAR(50)

)

AS

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

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

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

--DECLARE @DocDate VARCHAR(50) = '20240109'

DECLARE @Lot VARCHAR(100)

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

SELECT @Lot AS Lot