use of Sum SQL SERVER

Question

use of Sum SQL SERVER

Navigation

#1 by (4 votes)

1

I need to add everything that is in value;

This is my query

create procedure sp_DetalleDeduccionesEmpleado @inicio datetime, @final datetime, @emp int
as
select 
ded.DedId,
sum(ded.DetDedEmpValor),
emp.EmpId


from Tbl_DetalleDeduccionesEmpleado ded
inner join Tbl_Deducciones tip
 on tip.DedId = ded.DedId
 inner join Tbl_Empleado emp
 on emp.EmpId = ded.EmpId
 where ded.DetDedEmpFecha >=  @inicio and 
 ded.DetDedEmpFecha <= @final and 
 ded.EmpId = @emp
 group by ded.DedId, emp.EmpId



execute sp_DetalleDeduccionesEmpleado '2018-05-01', '2018-05-08', '2390'

sql c# sql-server

asked by Marco Eufragio 27.10.2018 в 00:13

source

1 answer

Use of td and tr How to move to a function for better organization in Python

score 4 · Accepted Answer

To do this, you must embed your initial selection, within a greater selection in the following way:

SELECT SUM(X.SumValor)  -- Sumas la columna especificada
FROM(
    select 
        ded.DedId,
        sum(ded.DetDedEmpValor) AS 'SumValor',  -- Aquí debes ponerle un alias
        emp.EmpId
    from Tbl_DetalleDeduccionesEmpleado ded
    inner join Tbl_Deducciones tip
        on tip.DedId = ded.DedId
    inner join Tbl_Empleado emp
        on emp.EmpId = ded.EmpId
    where ded.DetDedEmpFecha >=  @inicio and 
        ded.DetDedEmpFecha <= @final and 
        ded.EmpId = @emp
    group by ded.DedId, emp.EmpId
) AS X

NOTE: You can also use a CTE for this type of situation. Greetings.