SQL - Procedimiento Contador

SELECT @envio=replicate('0',8-LEN(CAST(@numEnvio AS VARCHAR))) + CAST(@numEnvio AS VARCHAR)

INSERT INTO #BancoCrediccop

SELECT 2 id, 'R' + @envio +

       replicate('0',11-len(CAST(ID AS VARCHAR))) + CAST(ID AS VARCHAR) +

       CAST(ltrim(rtrim(FIRMA)) AS VARCHAR(50)) + replicate(' ',50-len(CAST(ltrim(rtrim(FIRMA)) AS VARCHAR(50)))) +

       '0000000000000' +

       replicate('0',11-len( replace(ltrim(rtrim(CUIT)),'-',''))) +  replace(ltrim(rtrim(CUIT)),'-','') +

       replicate(' ',207) +

       '00001311' +

       'A'

FROM Clientes

WHERE DISCONTINUADO NOT IN ('D','S')

select @envio as id, row_number() over(order by ID asc)

SELECT	'R' + RTRIM(RIGHT(CAST(SEG1 AS CHAR(9)),8))+RTRIM(RIGHT(CAST(SEG2 AS CHAR(14)),13))

FROM (

		SELECT  SEG1 = 10000000 + ROW_NUMBER() OVER(ORDER BY ID ASC)

		,		SEG2 = 1000000000000 + ID

		FROM clientes

WHERE DISCONTINUADO NOT IN ('D','S')

) X