SQL - 在Store过程中使用参数调用函数

I have a situation like this:

我有这样的情况:

SELECT CONVERT(VARCHAR(40), CONVERT(BIGINT, C1.cod_cta)), 
       C1.cod_cta, 
       C1.descripcio 
FROM   table1 C1 
       JOIN (SELECT TOP 1 * 
             FROM   table2 
             ORDER  BY [date] DESC) C2 
         ON C2.somefield = 'SomeData' 
WHERE  C1.something = 1 
UNION ALL 
SELECT CONVERT(VARCHAR(40), CONVERT(BIGINT, C1.cod_cta)), 
       C1.cod_cta, 
       C1.descripcio 
FROM   table3 C1 
       JOIN (SELECT TOP 1 * 
             FROM   table2 
             ORDER  BY [date] DESC) C2 
         ON C2.somefield = 'SomeData' 
WHERE  C1.something = 1 
       AND NOT EXISTS (SELECT 1 
                       FROM   table1 C3 
                       WHERE  C3.cod_cta = C1.cod_cta) 
UNION ALL 
SELECT CONVERT(VARCHAR(40), CONVERT(BIGINT, C1.cod_cta)), 
       C1.cod_cta, 
       C1.descripcio 
FROM   table3 C1 
       JOIN (SELECT TOP 1 * 
             FROM   table2 
             ORDER  BY [date] DESC) C2 
         ON C2.somefield = 'SomeData' 
WHERE  C1.something = 1 
UNION ALL 
SELECT C1.importantfield COLLATE latin1_general_bin, 
       C1.importantfield COLLATE latin1_general_bin, 
       C1.desc_cuenta COLLATE latin1_general_bin 
FROM   table4 C1 
       JOIN (SELECT TOP 1 * 
             FROM   table2 
             ORDER  BY [date] DESC) C2 
         ON C2.somefield = 'SomeData'  
SELE