marco
2625 lines
182 KiB
Transact-SQL
2625 lines
182 KiB
Transact-SQL
set ANSI_NULLS on;
|
|
go
|
|
|
|
--IF OBJECT_ID (N'dbo.f_t_FindReports', N'TF') IS NOT NULL
|
|
-- DROP FUNCTION dbo.f_t_FindReports;
|
|
--GO
|
|
|
|
create FUNCTION f_t_FindReports ( @Data SmallDateTIME , @RifDitta NVARCHAR(3) )
|
|
RETURNS @retFindReports TABLE
|
|
(
|
|
dataLav date NOT NULL,
|
|
idxDipendente INT NOT NULL,
|
|
mm_straordinari decimal(9,3) NOT NULL,
|
|
gruppo NVARCHAR(50)
|
|
)
|
|
--Returns a result set that lists all the employees who report to the
|
|
--specific employee directly or indirectly.*/
|
|
AS
|
|
BEGIN
|
|
|
|
DECLARE @DataStart AS Date;
|
|
DECLARE @DataEnd AS Date;
|
|
DECLARE @nDip AS INT;
|
|
|
|
IF @Data IS NULL SET @Data = GETDATE(); -- se data passata è nulla setto a getdate
|
|
|
|
SET @DataStart = DATEADD(MONTH, DATEDIFF( MONTH, 0, @Data), 0);
|
|
SET @DataEnd = DATEADD(DAY, -1, DATEADD(MONTH, 1 ,@DataStart ) );
|
|
|
|
|
|
WITH EMP_cte -- CTE name and columns
|
|
AS (
|
|
SELECT -- Ore
|
|
t.idxDipendente
|
|
, d.matricola
|
|
, t.dataLav
|
|
, t.mm_ordinari AS minOrdExp -- minuti ordinari effettivi per export
|
|
, CASE WHEN t.mm_lavorati-t.mm_straordinari > 0
|
|
THEN (t.mm_lavorati-t.mm_straordinari)
|
|
ELSE 0
|
|
END AS minLavExp -- minuti Lavorati effettivi per export
|
|
, t.mm_straordinari AS minStraExp -- minuti straordinari effettivi per export
|
|
|
|
-- Giustificativi
|
|
, t.mm_permessi AS minPermExp
|
|
, t.mm_ferie AS minFerieExp
|
|
, t.minMal AS minMalExp
|
|
, t.mm_festivita AS minFestExp
|
|
|
|
-- parte iniziale Record
|
|
, RIGHT(dbo.f_expDataGGMMAAAA(dataLav),4)
|
|
+ SUBSTRING(dbo.f_expDataGGMMAAAA(dataLav),3,2)
|
|
+ ISNULL(@RifDitta,' ') -- Riferimento Ditta CHAR(3) ???
|
|
+ CONVERT(CHAR(4),ag.codExt) -- codice Ditta ( letto da AnagGruppi ) CHAR(4)
|
|
+ dbo.f_padLeft(d.matricola, 5, '0') + '0' -- 0 finale serve x doppio record x cambio qualifica ???
|
|
AS Record
|
|
,d.gruppo
|
|
FROM dbo.v_OreTimbratureDipendente AS t -- vista COMUNE con già le ore effettive calcolate
|
|
-- FROM dbo.TimbratureExpl AS t
|
|
INNER JOIN dbo.Dipendenti AS d ON t.idxDipendente = d.idxDipendente
|
|
INNER JOIN AnagGruppi ag ON d.gruppo = ag.gruppo
|
|
WHERE dataLav >= @DataStart AND dataLav < @DataEnd
|
|
-- AND ( d.gruppo = @gruppo OR ISNULL(@gruppo,'') = '' ) -- controllo gruppo! solo quello selezionato o tutti
|
|
AND ag.exportEnab = 1 -- gruppo attivo x export
|
|
)
|
|
-- copy the required columns to the result of the function
|
|
INSERT @retFindReports
|
|
SELECT dataLav, idxDipendente, minStraExp, gruppo
|
|
FROM EMP_cte
|
|
RETURN
|
|
END
|
|
|
|
-- Example invocation
|
|
--SELECT EmployeeID, FirstName, LastName, JobTitle, RecursionLevel
|
|
--FROM dbo.ufn_FindReports(1);
|
|
|
|
|
|
--SELECT * FROM dbo.f_t_FindReports ( '20130101', 'GA1' )
|
|
go
|
|
|
|
|
|
set xact_abort on;
|
|
go
|
|
|
|
begin transaction;
|
|
go
|
|
|
|
set ANSI_NULLS on;
|
|
go
|
|
|
|
-- =============================================
|
|
-- Author: GCarlo
|
|
-- Create date: 05-2013
|
|
-- Description: Export Ore Paghe x ETS - calcolo tenendo conto delle ore assorbite
|
|
-- =============================================
|
|
create PROCEDURE export.stp_orePerPaghe_OLD
|
|
-- parameters for the stored procedure
|
|
@data DATE = NULL,
|
|
@idxDipendente INT = NULL,
|
|
@RifDitta NVARCHAR(3) = 'EG1', -- riferimento "interno": va letto da "gruppo" poiché cambia x ogni loro "sottosocietà": ETS, XPanding, Studio Associato, SNOB
|
|
@gruppo NVARCHAR(50) = NULL
|
|
AS
|
|
BEGIN
|
|
|
|
SET NOCOUNT ON;
|
|
-- creo date Inizio-Fine Mese da processare
|
|
DECLARE @DataStart AS DATE;
|
|
DECLARE @DataEnd AS DATE;
|
|
|
|
IF @Data IS NULL SET @Data = GETDATE(); -- se data passata è nulla setto a getdate
|
|
|
|
SET @DataStart = DATEADD(MONTH, DATEDIFF( MONTH, 0, @Data), 0);
|
|
SET @DataEnd = DATEADD(DAY, -1, DATEADD(MONTH, 1 ,@DataStart ) );
|
|
|
|
IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
|
|
DROP TABLE #TempTable;
|
|
|
|
SELECT
|
|
ROW_NUMBER() OVER(PARTITION BY t.idxDipendente ORDER by t.dataLav ) AS Riga
|
|
, t.idxDipendente
|
|
, t.CognomeNome
|
|
, t.dataLav
|
|
, ag.codExt
|
|
, d.matricola
|
|
, t.entrata_1, t.uscita_1, t.entrata_2 , t.uscita_2, t.entrata_3 , t.uscita_3, t.entrata_4 , t.uscita_4
|
|
, t.isOkTim , t.isOkApp, t.isOkLav, t.isOk
|
|
-- parte iniziale Record x EXPORT PAGHE ETS
|
|
, RIGHT(dbo.f_expDataGGMMAAAA(dataLav),4) -- ANNO AAAA
|
|
+ SUBSTRING(dbo.f_expDataGGMMAAAA(dataLav),3,2) -- MESE MM
|
|
+ ISNULL(@RifDitta,'EG1') -- Riferimento Ditta CHAR(3) ???
|
|
+ CONVERT(CHAR(4),ag.codExt) -- codice Ditta ( letto da AnagGruppi ) CHAR(4)
|
|
+ dbo.f_padLeft(d.matricola, 5, '0') + '0' -- 0 finale serve x doppio record x cambio qualifica ???
|
|
AS Record
|
|
|
|
-- parte iniziale Record
|
|
, t.mm_ordinari AS minOrdExp -- minuti ordinari effettivi per export
|
|
, CASE WHEN t.mm_lavorati-t.mm_straordinari > 0
|
|
THEN (t.mm_lavorati-t.mm_straordinari)
|
|
ELSE 0
|
|
END AS minLavExp -- minuti Lavorati effettivi per export
|
|
, t.mm_straordinari AS minStra -- minuti straordinari
|
|
|
|
-- Giustificativi
|
|
, t.mm_permessi AS minPermExp
|
|
, t.mm_ferie AS minFerieExp
|
|
, t.minMal AS minMalExp
|
|
, t.mm_festivita AS minFestExp
|
|
, o.oreStraordAss
|
|
|
|
INTO #TempTable
|
|
FROM dbo.v_OreTimbratureDipendente AS t -- vista COMUNE con già le ore effettive calcolate
|
|
INNER JOIN dbo.Dipendenti AS d ON t.idxDipendente = d.idxDipendente
|
|
INNER JOIN dbo.AnagOrari AS o ON d.codOrario = o.codOrario
|
|
INNER JOIN dbo.AnagGruppi AS ag ON d.gruppo = ag.gruppo
|
|
|
|
WHERE dataLav >= @DataStart AND dataLav < @DataEnd
|
|
AND ( d.gruppo = @gruppo OR ISNULL(@gruppo,'') = '' ) -- controllo gruppo! solo quello selezionato o tutti
|
|
AND ag.exportEnab = 1 -- gruppo attivo x export
|
|
AND ( t.idxDipendente = @idxDipendente OR @idxDipendente IS NULL OR @idxDipendente = 0 )
|
|
|
|
-- SELECT * FROM #TempTable
|
|
|
|
-- Calcolo gli straordinari progressivi
|
|
-- Leggo solo i record con riga = 1 e poi estraggo tutti i successivi dello stesso dip in modo ricorsivo
|
|
;WITH cte
|
|
AS ( SELECT *, CONVERT( INT , minStra ) AS minStraProgr -- converto altrimenti mi da errore?!?!?
|
|
FROM #TempTable WHERE Riga = 1
|
|
UNION ALL
|
|
SELECT t.*, CONVERT( INT, ( t.minStra + t1.minStraProgr ) )
|
|
FROM #TempTable AS t
|
|
INNER JOIN cte AS t1
|
|
ON t.Riga = t1.Riga + 1 AND t.idxDipendente = t1.idxDipendente
|
|
)
|
|
SELECT * ,
|
|
CASE
|
|
WHEN minStraProgr - (cte.oreStraordAss * 60) <= 0 THEN 0
|
|
WHEN minStraProgr - (cte.oreStraordAss * 60) < minStra THEN minStraProgr - (cte.oreStraordAss * 60)
|
|
ELSE minStra
|
|
END AS minStraExp
|
|
INTO #expTable
|
|
FROM cte
|
|
ORDER BY idxDipendente, Riga
|
|
OPTION ( MAXRECURSION 0 );
|
|
|
|
IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
|
|
DROP TABLE #Sales
|
|
END
|
|
go
|
|
|
|
commit;
|
|
go
|
|
|
|
|
|
set xact_abort on;
|
|
go
|
|
|
|
begin transaction;
|
|
go
|
|
|
|
create table Storico_AnagFasi(
|
|
idxEv int not null identity constraint PK_Storico_AnagFasi primary key,
|
|
DataEv datetime,
|
|
idxFase int,
|
|
idxProgetto int,
|
|
codFase nvarchar(250),
|
|
idxFaseAncest int constraint DF_Storico_AnagFasi_idxFaseAncest default ((0)),
|
|
nomeFase nvarchar(250),
|
|
descrizioneFase nvarchar(250),
|
|
enableTime bit constraint DF_Storico_AnagFasi_enableTime default ((0)),
|
|
enableMoney bit constraint DF_Storico_AnagFasi_enableMoney default ((0)),
|
|
Attivo bit constraint DF_Storico_AnagFasi_Attivo default ((1)),
|
|
codClasse nvarchar(10),
|
|
codExt nvarchar(50),
|
|
budgetTime decimal(19,4),
|
|
budgetMoney decimal(19,4)
|
|
);
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', 'codice fase gerarchico (F.1.2. = Fase 1, sottofase 2) - aggiornare con trigger!', 'SCHEMA', 'dbo', 'TABLE', 'Storico_AnagFasi', 'COLUMN', 'codFase';
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'fase ANCESTOR (contenitore), 0 = è top level', 'SCHEMA', 'dbo', 'TABLE', 'Storico_AnagFasi', 'COLUMN', 'idxFaseAncest';
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', 'indica se sia abilitata o meno a ricevere assegnazioni di record temporali', 'SCHEMA', 'dbo', 'TABLE', 'Storico_AnagFasi', 'COLUMN', 'enableTime';
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', 'indica se sia abilitata o meno a ricevere assegnazioni di record di spesa', 'SCHEMA', 'dbo', 'TABLE', 'Storico_AnagFasi', 'COLUMN', 'enableMoney';
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', 'codice univoco', 'SCHEMA', 'dbo', 'TABLE', 'Storico_AnagFasi', 'COLUMN', 'codClasse';
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', 'codice esterno', 'SCHEMA', 'dbo', 'TABLE', 'Storico_AnagFasi', 'COLUMN', 'codExt';
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', 'Budget del progetto (in ore)', 'SCHEMA', 'dbo', 'TABLE', 'Storico_AnagFasi', 'COLUMN', 'budgetTime';
|
|
go
|
|
|
|
create table Storico_AnagProgetti(
|
|
idxEv int not null identity constraint PK_Storico_AnagProgetti primary key,
|
|
DataEv datetime,
|
|
idxProgetto int,
|
|
idxCliente int,
|
|
nomeProj nvarchar(50),
|
|
descrProj nvarchar(250),
|
|
OldIdx int,
|
|
Attivo bit constraint DF_Storico_AnagProgetti_Attivo default ((1)),
|
|
codExt nvarchar(50),
|
|
avvio datetime,
|
|
chiusura datetime
|
|
);
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', 'codice esterno', 'SCHEMA', 'dbo', 'TABLE', 'Storico_AnagProgetti', 'COLUMN', 'codExt';
|
|
go
|
|
|
|
commit;
|
|
go
|
|
|
|
|
|
set xact_abort on;
|
|
go
|
|
|
|
begin transaction;
|
|
go
|
|
|
|
drop table Giustificativi_bck;
|
|
go
|
|
|
|
drop table PeriodiLav_bck;
|
|
go
|
|
|
|
drop table TimbratureExpl_bck;
|
|
go
|
|
|
|
drop table Timbrature_bck;
|
|
go
|
|
|
|
commit;
|
|
go
|
|
|
|
|
|
set xact_abort on;
|
|
go
|
|
|
|
begin transaction;
|
|
go
|
|
|
|
set ANSI_NULLS on;
|
|
go
|
|
|
|
/*************************************************************
|
|
* Trigger su delete/update
|
|
*
|
|
* Storicizza valori precedenti della tabella
|
|
*
|
|
* ultima modifica: S.E. Locatelli - 2013.04.29
|
|
**************************************************************/
|
|
create TRIGGER trg_AP_storicizza
|
|
ON AnagProgetti
|
|
FOR UPDATE, DELETE
|
|
AS
|
|
|
|
/* IF UPDATE() ... */
|
|
|
|
-- in caso di update e delete vado BRUTALMENTE a salvare record precedente in tabella storico relativa...
|
|
INSERT INTO Storico_AnagProgetti
|
|
SELECT GETDATE(), d.* FROM DELETED d
|
|
go
|
|
|
|
commit;
|
|
go
|
|
|
|
|
|
set xact_abort on;
|
|
go
|
|
|
|
begin transaction;
|
|
go
|
|
|
|
set ANSI_NULLS on;
|
|
go
|
|
|
|
/*************************************************************
|
|
* Trigger su delete/update
|
|
*
|
|
* Storicizza valori precedenti della tabella
|
|
*
|
|
* ultima modifica: S.E. Locatelli - 2013.04.29
|
|
**************************************************************/
|
|
create TRIGGER trg_AF_storicizza
|
|
ON AnagFasi
|
|
FOR UPDATE, DELETE
|
|
AS
|
|
|
|
/* IF UPDATE() ... */
|
|
|
|
-- in caso di update e delete vado BRUTALMENTE a salvare record precedente in tabella storico relativa...
|
|
INSERT INTO Storico_AnagFasi
|
|
SELECT GETDATE(), d.* FROM DELETED d
|
|
go
|
|
|
|
commit;
|
|
go
|
|
|
|
|
|
set xact_abort on
|
|
go
|
|
|
|
begin transaction
|
|
go
|
|
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-24' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-25' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-26' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-27' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-28' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-29' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-30' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-03-31' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-01' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-02' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-03' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-04' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-05' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-06' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-07' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-08' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-09' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-10' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-11' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-12' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-13' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-14' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-15' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-16' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-17' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-18' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-19' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-20' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-21' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-22' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-23' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-24' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-25' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-26' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-27' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-28' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-29' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-04-30' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-01' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-02' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-03' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-04' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-05' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-06' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-07' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-08' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-09' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-10' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-11' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-12' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-13' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-14' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-15' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-16' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-17' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-18' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-19' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-20' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-21' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-22' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-23' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-24' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-24' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-24' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-24' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-24' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-24' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-24' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-25' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-25' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-25' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-25' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-25' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-25' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-26' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-26' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-26' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-26' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-26' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-26' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-27' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-27' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-27' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-27' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-27' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-27' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-27' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=1
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=3
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=4
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=5
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=6
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=7
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=9
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=11
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=12
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=13
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=14
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=15
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=16
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=17
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=18
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=20
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=21
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=22
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=23
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=24
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=25
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=26
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=27
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=28
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=29
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=30
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=31
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=32
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=33
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=34
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-28' and idxDipendente=35
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-29' and idxDipendente=2
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-29' and idxDipendente=8
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-29' and idxDipendente=10
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-29' and idxDipendente=19
|
|
DELETE FROM dbo.RegAttivitaExpl WHERE dataLav='2013-05-29' and idxDipendente=34
|
|
go
|
|
|
|
commit transaction
|
|
go
|
|
|
|
set xact_abort on
|
|
go
|
|
|
|
begin transaction
|
|
go
|
|
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=48
|
|
go
|
|
|
|
commit transaction
|
|
go
|
|
|
|
|
|
set xact_abort on
|
|
go
|
|
|
|
begin transaction
|
|
go
|
|
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=47
|
|
go
|
|
|
|
commit transaction
|
|
go
|
|
|
|
|
|
set xact_abort on
|
|
go
|
|
|
|
begin transaction
|
|
go
|
|
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=21
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=23
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=33
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=37
|
|
go
|
|
|
|
commit transaction
|
|
go
|
|
|
|
|
|
set xact_abort on
|
|
go
|
|
|
|
begin transaction
|
|
go
|
|
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=20
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=22
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=28
|
|
DELETE FROM dbo.RegAttivita WHERE idxRA=29
|
|
go
|
|
|
|
commit transaction
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- registro versione...
|
|
INSERT INTO [dbo].[LogUpdateDb] ([Versione],[Data]) VALUES(340, GETDATE())
|
|
GO
|
|
SELECT * FROM LogUpdateDb ORDER BY Versione DESC |