Quote from Gregory Boge on January 18, 2018, 16 h 15 min

Hello,

You can find the 2nd Beta version here

To be able to use it, you must first execute this script on your kankuru database :

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteHistory]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.DeleteHistory AS'
END
GO
ALTER PROCEDURE DeleteHistory
@TYPE CHAR(1)
, @DAYS INT
, @BATCHSIZE INT = 5000
AS
BEGIN
SET NOCOUNT ON;
DECLARE @ROWCOUNT INT = @BATCHSIZE
IF @DAYS > 0
BEGIN
SET @DAYS = @DAYS * -1
END
WHILE @ROWCOUNT > 0
BEGIN
DELETE TOP (@BATCHSIZE)
FROM dbo.k_dashboard_historique
WHERE horodatage < DATEADD(DAY, @DAYS, GETDATE())
AND typesauvegarde = @TYPE
SET @ROWCOUNT = @@ROWCOUNT
END
END
GO
IF NOT EXISTS (SELECT * FROM dbo.k_dashboard WHERE id = 1101)
BEGIN
INSERT INTO dbo.k_dashboard(id,valeur) VALUES (1101, 50)
END
IF NOT EXISTS (SELECT * FROM dbo.k_dashboard WHERE id = 1102)
BEGIN
INSERT INTO dbo.k_dashboard(id,valeur) VALUES (1102, 50)
END
IF NOT EXISTS (SELECT * FROM dbo.k_dashboard WHERE id = 1103)
BEGIN
INSERT INTO dbo.k_dashboard(id,valeur) VALUES (1103, 50)
END
IF NOT EXISTS (SELECT * FROM dbo.k_dashboard WHERE id = 1104)
BEGIN
INSERT INTO dbo.k_dashboard(id,valeur) VALUES (1104, 50)
END