La línea marcada en rojo debería llevar la misma variable (@IdPeriodo)
Y sin embargo la tuve que redeclarar para que el query funcióne alguien me
podría decir porque?
No me estoy dando cuenta donde esta el error
Gracias
------------------------------------------------
Asi funciona…
Declare @IdP int
Set @[EMAIL PROTECTED]
SELECT
@IdPeriodo AS Idperiodo, CostoSinMG.IdEstandar AS idestandar,
CostoSinMG.CstUniVarImp, CostoSinMG.CstUniSFNac,CostoSinMG.CstUniSFImp,
INTO [#CostosporProducto]
FROM (SELECT IdEstandar, CodigoCentroCosto, IdProducto,
SUM(CstUniVarNac) AS CstUniVarNac, SUM(CstUniVarImp) AS
CstUniVarImp, SUM(CstUniSFNac)
AS CstUniSFNac, SUM(CstUniSFImp) AS CstUniSFImp,
MAX(ConstanteTransformacion)
AS ConstanteTransformacion FROM tFlexCostoTransformacionDetalle
* *
* WHERE (IdPeriodo = @IdP) AND (NOT (IdEstandar =0))
AND *
(CodigoCentroCosto IN (SELECT CodigoCentroCosto FROM tFlexCentrosCosto
WHERE (CentroFaseLiquida
= 0)))
GROUP BY IdPeriodo, CodigoCentroCosto, IdEstandar, IdProducto)
AS CostoSinMG LEFT OUTER JOIN
tFlexEstandares AS StdPAM ON StdPAM.IdEstandar =
CostoSinMG.IdEstandar AND StdPAM.CodigoTipoEstandar = '03' AND
StdPAM.IdPeriodo = @IdPeriodo AND
StdPAM.CodigoCentroCosto = CostoSinMG.CodigoCentroCosto INNER JOIN
tFlexTiposEstandares AS SignoPAM ON
SignoPAM.CodigoTipoEstandar = StdPAM.CodigoTipoEstandar LEFT OUTER JOIN
(SELECT CodigoCentroCosto, SUM(CstUniVarNac)
AS CstUniVarNac, SUM(CstUniVarImp) AS CstUniVarImp, SUM(CstUniSFNac) AS
CstUniSFNac,
SUM(CstUniSFImp) AS
CstUniSFImp
FROM tFlexCostoTransformacionDetalle
WHERE (IdPeriodo = @IdPeriodo) AND
(IdEstandar = 0)
GROUP BY CodigoCentroCosto) AS MG ON
MG.CodigoCentroCosto = CostoSinMG.CodigoCentroCosto
--
Ricardo A. Macrino
Sistemas Microsoft
Puntonet c#
Capital Federal - Rep. Argentina
