Jasc
25 de Abril del 2005

Hola

la verdad se que yo no trabajo mucho con procedimientos almacenados y me gustaria saber lo siguiente:

Yo tengo el siguiente procedimiento almacenado

CREATE PROCEDURE SUMACONTRATO
(@CATEGORIA_1 [INT],
@MES_1 [INT],
@DIA_1 [INT],
@SENTIDO_1 [INT],
@CONTRATO_1 [NVARCHAR],
@ANO_1 [INT])

AS
Select sum(h0) AS GT0,
sum(h1) AS GT1,
sum(h2) AS GT2,
sum(h3) AS GT3,
sum(h4) AS GT4,
sum(h5) AS GT5,
sum(h6) AS GT6,
sum(h7) AS GT7,
sum(h8) AS GT8,
sum(h9) AS GT9,
sum(h10) AS GT10,
sum(h11) AS GT11,
sum(h12) AS GT12,
sum(h13) AS GT13,
sum(h14) AS GT14,
sum(h15) AS GT15,
sum(h16) AS GT16,
sum(h17) AS GT17,
sum(h18) AS GT18,
sum(h19) AS GT19,
sum(h20) AS GT20,
sum(h21) AS GT21,
sum(h22) AS GT22,
sum(h23) AS GT23
FROM [concesiones].[concesiones].[FLUJOS]
WHERE
[cat_cod_cat]= @CATEGORIA_1
AND [mes] = @MES_1
AND [dia] = @DIA_1
AND [SENTIDO] = @SENTIDO_1
AND [con_cod_contrato]= '@CONTRATO_1'
AND [ANO]= @ANO_1
GO
y al momento de verificarlo en el analizador de consultas me da el siguiente error



incorrect syntax near ' 1 '





ojala alguien me pudiera ayudar a resolver mi problema

GabrielSR2004
25 de Abril del 2005

Sadulos mi estimado

Francamente no veo algun problema, almenos que sea la estructura de tu tabla.

porque no me pasas la estructura de tu tabla