Having ?

[Ledian_Fdez]

Empezado por Kipow

Código SQL [-]
CREATE   PROCEDURE Extra_calculo_diaferiados

@fechaI datetime,
@fechaF datetime

AS

SELECT A, B, C, sum(D) as Dias, sum(O) as Cobrar, min(Fecha) as FIni
FROM   Tabla
WHERE (fecha between  @fechaI and @fechaF)
GROUP BY A, B, C
ORDER BY A, B

:saber:

Fecha is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.