Thank for your responses and your help! Much obliged!

I have solved it and created the following procedure:

CREATE PROCEDURE Raport4

@since DATETIME,

@until DATETIME,

@Location VARCHAR(255)

AS

BEGIN

SELECT LocationName, SUM(NUMARACTIVARI) NUMARACTIVARI, SUM(NUMARDEZACTIVARI) NUMARDEZACTIVARI, SUM(VALOAREINTRARI) VALOAREINTRARI,...

The first two are COUNT - while the other two are SUM. Nevertheless here's what I have right now:

DECLARE @since DATETIME

DECLARE @until DATETIME

DECLARE @Operatie1 INT

DECLARE @Operatie2 INT

DECLARE @Operatie3 INT

SET @since...

The output I want to get is:

Location | Numar activari(OP.1) | Nr dezactivari(OP.2) | Valoare IN(sum(OP3)) | Valoare OUT (sum(OP4))

DemoLocation1 | 3...

In case the script encounters errors and it did what must I add to it so that

1. if an identical line (record) exists already when inserting into table - to...

...and after [eMail2] as well. Spent almost 2 hours trying to figure this out... 😀

Thank you for pointing it out - I am a SQL newbie and I...