hazlo un procedure que te reciba un valor algo asi
Código SQL:
Ver originalCREATE PROCEDURE sp_testing (@region VARCHAR(20))
AS
DECLARE @FASE AS VARCHAR(1)
SET @FASE = '1'
SELECT @TOTALF1 = COUNT(C.[Nombre RH])
FROM S_VW_Cursos A
INNER JOIN COURSE_USERS B ON B.CRSMAIN_PK1 = A.PK1
INNER JOIN S_VW_Usuarios C ON C.PK1 = B.USERS_PK1
INNER JOIN GRADEBOOK_MAIN D ON D.CRSMAIN_PK1 = A.PK1
INNER JOIN GRADEBOOK_GRADE E ON E.GRADEBOOK_MAIN_PK1 = D.PK1 AND E.COURSE_USERS_PK1 = B.PK1
INNER JOIN ATTEMPT F ON F.PK1 = E.HIGHEST_ATTEMPT_PK1
WHERE D.Title = 'BAJA'
AND B.ROLE = 'S'
AND A.Clave LIKE '%EC-F'+@FASE+'-' + @REGION + '%'
AND A.Clave NOT LIKE '%PDC%'
AND A.Clave NOT LIKE '%PT%'
-
SELECT 'REGION ' AS [TOTAL DE INGRESO F1]+ @TOTALF1 AS [TOTAL DE INGRESO F1]
, ((@TOTALF1 * 100) / @TOTALF1 ) AS [% DE EFICIENCIA F1]