Store Procedure

[margotpalacios]

El código completo es así:
SP:
CREATE PROCEDURE dbo.sp_Web_ResumenMensual
@fecha varchar(6) = NULL,
@sentido varchar(2) = NULL

AS
BEGIN
SELECT tr.REG_NOMBRE_LARGO as Region,
Intentos1=CASE WHEN t1.S_BID IS NULL THEN 0 ELSE t1.S_BID END ,
Contestadas1=CASE WHEN t1.S_ANSW IS NULL THEN 0 ELSE t1.S_ANSW END,
Intentos2= CASE WHEN t2.S_BID IS NULL THEN 0 ELSE t2.S_BID END,
Contestadas2=CASE WHEN t2.S_ANSW IS NULL THEN 0 ELSE t2.S_ANSW END,
TotalIntentos= CASE WHEN t1.S_BID IS NULL THEN 0 ELSE t1.S_BID END + CASE WHEN t2.S_BID IS NULL THEN 0 ELSE t2.S_BID END,
TotalContestadas =CASE WHEN t1.S_ANSW IS NULL THEN 0 ELSE t1.S_ANSW END + CASE WHEN t2.S_ANSW IS NULL THEN 0 ELSE t2.S_ANSW END
FROM tab_sempro_totreg_LD t1,
tab_sempro_totreg_LD t2,
BD_COMUNES..TAB_REGION tr
WHERE t1.CODIGO_REGION =* tr.REG_COD_REGION
AND t2.CODIGO_REGION=* tr.REG_COD_REGION
AND t1.RUT_COD_C4 = '2001'
AND t2.RUT_COD_C4 = '2002'
AND Convert(char(6),t1.FECHA,12) = @fecha
AND Convert(char(6),t2.FECHA,12) = @fecha
AND t1.LADO_TRAFICO = 1
AND t2.LADO_TRAFICO = 1
AND t1.SEN_TRAFICO = @sentido
AND t2.SEN_TRAFICO = @sentido
AND tr.REG_COD_PAIS = 225
END

En la página:
$sql_vm1 = "EXEC sp_Web_ResumenMensual '$varFecha', 'VM'";
$recordSet_VM = $conn->Execute('sp_Web_ResumenMensual'.$varFecha.','.$se ntido);

La versión del PHP es 3.0 y uso IIS 5