CREATE FUNCTION dbo.fnGetSSCC
(
	@SSCC VARCHAR(17)
)
RETURNS VARCHAR(18)
AS
BEGIN
	DECLARE	@Index TINYINT,
		@Multiplier TINYINT,
		@Sum SMALLINT

	SELECT	@Index = LEN(@SSCC),
		@Multiplier = 3,
		@Sum = 0

	WHILE @Index > 0
		SELECT	@Sum = @Sum + @Multiplier * CAST(SUBSTRING(@SSCC, @Index, 1) AS TINYINT),
			@Multiplier = 4 - @Multiplier,
			@Index = @Index - 1

	RETURN	CASE @Sum % 10
			WHEN 0 THEN @SSCC + '0'
			ELSE @SSCC + CAST(10 - @Sum % 10 AS CHAR(1))
		END
END