DECLARE @_CodeInput NVARCHAR(20) = '32-31-55-61-21-16' -- Mã chương trình: EX: 16-19-78-72-57-51.
DECLARE @_GetDate INT
DECLARE @_CodeOut NVARCHAR(6)
DECLARE @_Str1 INT,@_Str2 INT,@_Str3 INT, @_Str4 INT,@_Str5 INT,
@_Str6 INT,@_Str7 INT,@_Str8 INT, @_Str9 INT,@_Str10 INT
SET @_Str1 = RIGHT(LEFT(@_CodeInput,2),1) SET @_Str6 = RIGHT(LEFT(@_CodeInput,10),1)
SET @_Str2 = RIGHT(LEFT(@_CodeInput,4),1)SET @_Str7 = RIGHT(LEFT(@_CodeInput,11),1)
SET @_Str3 = RIGHT(LEFT(@_CodeInput,5),1)SET @_Str8 = RIGHT(LEFT(@_CodeInput,13),1)
SET @_Str4 = RIGHT(LEFT(@_CodeInput,7),1)SET @_Str9 = RIGHT(LEFT(@_CodeInput,14),1)
SET @_Str5 = RIGHT(LEFT(@_CodeInput,8),1)SET @_Str10 = RIGHT(LEFT(@_CodeInput,16),1)
SET @_GetDate = (SELECT datepart(DD,GETDATE()))
IF LEN(@_GetDate)=1
SET @_GetDate = (CAST(LEFT(@_GetDate,1) AS INT))*2
ELSE
SET @_GetDate = (CAST(LEFT(@_GetDate,1) AS INT)+CAST(RIGHT(@_GetDate,1) AS INT))*2
SET @_GetDate = RIGHT(@_GetDate,1)
SET @_Str1 = RIGHT((@_Str1 + @_Str2)*2,1)
SET @_Str3 = RIGHT((@_Str3 + @_Str4)*2,1)
SET @_Str5 = RIGHT((@_Str5 + @_Str6)*2,1)
SET @_Str7 = RIGHT((@_Str7 + @_Str8)*2,1)
SET @_Str9 = RIGHT((@_Str9 + @_Str10)*2,1)
PRINT CAST(@_GetDate AS NVARCHAR(2))+CAST(@_Str1 AS NVARCHAR(2))+
CAST(@_Str3 AS NVARCHAR(2))+CAST(@_Str5 AS NVARCHAR(2))+
CAST(@_Str7 AS NVARCHAR(2))+CAST(@_Str9 AS NVARCHAR(2))