Query optimization

Question

Query optimization

tomisoft

Newbie

Points: 6
More actions
September 18, 2015 at 5:01 am

#320719

Hello,
I have a view which I'm trying to optimize.
Here's original one:
ALTER VIEW [dbo].[V_Smeny_D]
AS
SELECT s.ARBPLNR, s.DATUM, master.dbo.spt_values.number AS smena, DATEADD(hh, CASE number WHEN 1 THEN 0 WHEN 2 THEN 6 WHEN 3 THEN 14 ELSE 22 END, CAST(s.DATUM AS datetime2)) AS _od, DATEADD(mi, (CASE number WHEN 1 THEN dbo.S3_len(datum, arbplnr, 0) + (SELECT P3 FROM dbo.SMENNOST WHERE (DATUM = DATEADD(day, - 1, s.DATUM)) AND (ARBPLNR = s.ARBPLNR)) WHEN 2 THEN 6 + S1 + P1 WHEN 3 THEN 14 + S2 + P2 ELSE 22 + (CASE WHEN S3 > 2 THEN 2 ELSE s3 END) END) * 60, CAST(s.DATUM AS datetime2)) AS _do
FROM dbo.SMENNOST AS s
CROSS JOIN master.dbo.spt_values
WHERE (master.dbo.spt_values.type = 'P') AND (master.dbo.spt_values.number BETWEEN 1 AND 4) AND (CASE number WHEN 1 THEN dbo.S3_len(datum, arbplnr, 0) WHEN 2 THEN S1 WHEN 3 THEN S2 ELSE S3 END <> 0)
which I've tried to optimize into:
ALTER VIEW [dbo].[V_Smeny_D]
AS
SELECT s.ARBPLNR, s.DATUM, cs.ID_CSMENA as smena,
DATEADD(hh, cs.START_HOUR, CAST(s.DATUM AS datetime2)) AS _od,
DATEADD(mi, (CASE cs.ID_CSMENA
WHEN 1 THEN dbo.S3_len_full(0, s1.S3) + s1.P3
WHEN 2 THEN cs.START_HOUR + s.S1 + s.P1
WHEN 3 THEN cs.START_HOUR + s.S2 + s.P2
ELSE cs.START_HOUR + IIF(s.S3 > 2, 2, s.S3)
END) * 60, CAST(s.DATUM AS datetime2)) AS _do
FROM dbo.SMENNOST s
LEFT JOIN dbo.SMENNOST s1
ON (s1.ARBPLNR = s.ARBPLNR) AND
(s1.DATUM = DATEADD(day, -1, s.DATUM))
CROSS JOIN dbo.CSMENA AS cs
WHERE
(CASE cs.ID_CSMENA
WHEN 1 THEN dbo.S3_len_full(0, s1.S3)
WHEN 2 THEN s.S1
WHEN 3 THEN s.S2
ELSE s.S3
END <> 0)
master.dbo.spt_values table was replaced by new CSMENA table which contains just 4 rows.
I have also another view which is using first one:
ALTER VIEW [dbo].[V_Prostoje_D_priprava]
AS
SELECT 'SMF ' AS WERK, s.ARBPLNR, s.DATUM AS dat, p.Kategorie, SUM(dbo.IntervalIntersection(e.TIME, e.TIME2, s._od, s._do)) AS prostoje, COUNT(dbo.IntervalIntersection(e.TIME, e.TIME2, s._od, s._do)) AS pocet
FROM dbo.Events e
JOIN dbo.V_Smeny_D s
ON (s.ARBPLNR = e.ARBPLNR) AND
(s._od <= e.TIME2) AND
(s._do >= e.TIME)
JOIN dbo.PROSTOJE p
ON p.ID = e._KEY
WHERE
(e.TYPE = 'p')
GROUP BY s.ARBPLNR, s.DATUM, p.Kategorie
When I run V_Smeny_D alone nothing non standard happened - query runs under 1s, but
when I run V_Prostoje_D_priprava with "optimized" version of V_Smeny_D it executes approximately 10x slower than original one. Can anybody explain me why? When I looked on execution plans of both version that original one costs 0,76(subtree) and optimized one costs 0,38 (subtree).
Thanks a lot

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182951 More actions · Answer 1

tomisoft (9/18/2015)
Hello,
I have a view which I'm trying to optimize.
Here's original one:
ALTER VIEW [dbo].[V_Smeny_D]
AS
SELECT s.ARBPLNR, s.DATUM, master.dbo.spt_values.number AS smena, DATEADD(hh, CASE number WHEN 1 THEN 0 WHEN 2 THEN 6 WHEN 3 THEN 14 ELSE 22 END, CAST(s.DATUM AS datetime2)) AS _od, DATEADD(mi, (CASE number WHEN 1 THEN dbo.S3_len(datum, arbplnr, 0) + (SELECT P3 FROM dbo.SMENNOST WHERE (DATUM = DATEADD(day, - 1, s.DATUM)) AND (ARBPLNR = s.ARBPLNR)) WHEN 2 THEN 6 + S1 + P1 WHEN 3 THEN 14 + S2 + P2 ELSE 22 + (CASE WHEN S3 > 2 THEN 2 ELSE s3 END) END) * 60, CAST(s.DATUM AS datetime2)) AS _do
FROM dbo.SMENNOST AS s
CROSS JOIN master.dbo.spt_values
WHERE (master.dbo.spt_values.type = 'P') AND (master.dbo.spt_values.number BETWEEN 1 AND 4) AND (CASE number WHEN 1 THEN dbo.S3_len(datum, arbplnr, 0) WHEN 2 THEN S1 WHEN 3 THEN S2 ELSE S3 END <> 0)
which I've tried to optimize into:
ALTER VIEW [dbo].[V_Smeny_D]
AS
SELECT s.ARBPLNR, s.DATUM, cs.ID_CSMENA as smena,
DATEADD(hh, cs.START_HOUR, CAST(s.DATUM AS datetime2)) AS _od,
DATEADD(mi, (CASE cs.ID_CSMENA
WHEN 1 THEN dbo.S3_len_full(0, s1.S3) + s1.P3
WHEN 2 THEN cs.START_HOUR + s.S1 + s.P1
WHEN 3 THEN cs.START_HOUR + s.S2 + s.P2
ELSE cs.START_HOUR + IIF(s.S3 > 2, 2, s.S3)
END) * 60, CAST(s.DATUM AS datetime2)) AS _do
FROM dbo.SMENNOST s
LEFT JOIN dbo.SMENNOST s1
ON (s1.ARBPLNR = s.ARBPLNR) AND
(s1.DATUM = DATEADD(day, -1, s.DATUM))
CROSS JOIN dbo.CSMENA AS cs
WHERE
(CASE cs.ID_CSMENA
WHEN 1 THEN dbo.S3_len_full(0, s1.S3)
WHEN 2 THEN s.S1
WHEN 3 THEN s.S2
ELSE s.S3
END <> 0)
master.dbo.spt_values table was replaced by new CSMENA table which contains just 4 rows.
I have also another view which is using first one:
ALTER VIEW [dbo].[V_Prostoje_D_priprava]
AS
SELECT 'SMF ' AS WERK, s.ARBPLNR, s.DATUM AS dat, p.Kategorie, SUM(dbo.IntervalIntersection(e.TIME, e.TIME2, s._od, s._do)) AS prostoje, COUNT(dbo.IntervalIntersection(e.TIME, e.TIME2, s._od, s._do)) AS pocet
FROM dbo.Events e
JOIN dbo.V_Smeny_D s
ON (s.ARBPLNR = e.ARBPLNR) AND
(s._od <= e.TIME2) AND
(s._do >= e.TIME)
JOIN dbo.PROSTOJE p
ON p.ID = e._KEY
WHERE
(e.TYPE = 'p')
GROUP BY s.ARBPLNR, s.DATUM, p.Kategorie
When I run V_Smeny_D alone nothing non standard happened - query runs under 1s, but
when I run V_Prostoje_D_priprava with "optimized" version of V_Smeny_D it executes approximately 10x slower than original one. Can anybody explain me why? When I looked on execution plans of both version that original one costs 0,76(subtree) and optimized one costs 0,38 (subtree).
Thanks a lot

Hi and welcome to the forum!

Quick question, can you post the DDL (create table), preferably some sample data as an insert statement and the actual execution plans for the different versions?

😎

tomisoft Newbie Points: 6 More actions · Answer 2

Thanks for invitation, here are they:

DDL:

CREATE TABLE [dbo].[SMENNOST](

[ARBPLNR] [char](8) NOT NULL,

[DATUM] [date] NOT NULL,

[S1] [numeric](2, 1) NULL,

[S2] [numeric](2, 1) NULL,

[S3] [numeric](2, 1) NULL,

[P1] [numeric](4, 2) NULL,

[P2] [numeric](4, 2) NULL,

[P3] [numeric](4, 2) NULL,

[PERS1] [numeric](3, 0) NULL,

[PERS2] [numeric](3, 0) NULL,

[PERS3] [numeric](3, 0) NULL,

CONSTRAINT [PK_SMENNOST] PRIMARY KEY CLUSTERED

(

[ARBPLNR] ASC,

[DATUM] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

CREATE TABLE [dbo].[CSMENA](

[ID_CSMENA] [int] NOT NULL,

[START_HOUR] [tinyint] NOT NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[Events](

[TIME] [datetime] NOT NULL,

[ARBPLNR] [varchar](8) NOT NULL,

[TYPE] [varchar](2) NOT NULL,

[_KEY] [varchar](10) NULL,

[TIME2] [datetime] NULL

) ON [PRIMARY]

CREATE FUNCTION [dbo].[S3_len]

(

@Datum DATE,

@pracoviste as VARCHAR(8),

@S3 as NUMERIC(2,1)

)

RETURNS NUMERIC(4,2)

AS

BEGIN

DECLARE @ResultVar NUMERIC(4,2)

DECLARE @hod NUMERIC(4,2)

DECLARE @pres NUMERIC(4,2)

SELECT @hod = S3, @pres = P3 FROM dbo.smennost AS s1

WHERE s1.DATUM = dateadd(day, - 1, @datum) AND s1.ARBPLNR = @pracoviste

IF @hod > 2

begin

SET @ResultVar = @hod - 2

end

else

begin

SET @ResultVar = 0

end

IF @S3 > 2

begin

SET @ResultVar = @ResultVar + 2

end

else

begin

SET @ResultVar = @ResultVar + @S3

end

RETURN @ResultVar

END

CREATE FUNCTION [dbo].[S3_len_full]

(

@S3 as NUMERIC(2,1),

@S3_day_before NUMERIC(4,2)

)

RETURNS NUMERIC(4,2)

AS

BEGIN

DECLARE @result NUMERIC(4,2)

IF @S3_day_before > 2

SET @result = @S3_day_before - 2

ELSE

SET @result = 0

IF @S3 > 2

SET @result = @result + 2

ELSE

SET @result = @result + @S3

RETURN @result

END

CREATE FUNCTION [dbo].[IntervalIntersection](@od datetime, @do datetime, @od1 datetime, @do1 datetime) RETURNS int AS

BEGIN

RETURN CASE

WHEN @od < @od1 AND @do <= @do1 THEN datediff(s, @od1, @do)

WHEN @od < @od1 AND @do > @do1 THEN datediff(s, @od1, @do1)

WHEN @do > @do1 THEN datediff(s, @od, @do1)

ELSE datediff(s, @od, @do)

END

Data:

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-01', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-02', 7.5, 7.5, 7.5, 0.50, 0.50, 0.50, 1, 1, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-03', 7.5, 7.5, 7.5, 0.50, 0.50, 0.50, 1, 1, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-04', 7.5, 7.5, 7.5, 0.50, 0.50, 0.50, 1, 1, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-05', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-06', 7.5, 0.0, 0.0, 0.50, 0.00, 0.00, 1, 0, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-07', 0.0, 0.0, 7.5, 0.00, 0.00, 0.50, 0, 0, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-08', 7.5, 7.5, 7.5, 0.50, 0.50, 0.50, 1, 1, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-09', 7.5, 7.5, 7.5, 0.50, 0.50, 0.50, 1, 1, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-10', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-11', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-12', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-13', 7.5, 0.0, 0.0, 0.50, 0.00, 0.00, 1, 0, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-15', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-16', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-17', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-18', 7.5, 7.5, 7.5, 0.50, 0.50, 0.50, 1, 1, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-19', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-20', 7.5, 0.0, 0.0, 0.50, 0.00, 0.00, 1, 0, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-21', 0.0, 0.0, 2.0, 0.00, 0.00, 0.00, 0, 0, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-22', 7.5, 7.5, 7.5, 0.50, 0.50, 0.50, 1, 1, 1);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-23', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-24', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-25', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-26', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-27', 7.5, 0.0, 0.0, 0.50, 0.00, 0.00, 1, 0, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-29', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-06-30', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-01', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-02', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-03', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-07', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-08', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-09', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-10', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-13', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-14', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-15', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-16', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-17', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-20', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-21', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-22', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-23', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-24', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-27', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-28', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-29', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-30', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-07-31', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-03', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-04', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-05', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-06', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-07', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-10', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-11', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-12', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-13', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-14', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-17', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-18', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-19', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-20', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-21', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-24', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-25', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-26', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-27', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-28', 7.5, 0.0, 0.0, 0.50, 0.00, 0.00, 1, 0, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-08-31', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-01', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-02', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-03', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-04', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-07', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-08', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-09', 7.5, 0.0, 0.0, 0.50, 0.00, 0.00, 1, 0, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-10', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-11', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-14', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-15', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-16', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-17', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.SMENNOST (ARBPLNR, DATUM, S1, S2, S3, P1, P2, P3, PERS1, PERS2, PERS3) VALUES ('541240 ', '2015-09-18', 7.5, 7.5, 0.0, 0.50, 0.50, 0.00, 1, 1, 0);

INSERT INTO dbo.CSMENA (ID_CSMENA, START_HOUR) VALUES (1, 0);

INSERT INTO dbo.CSMENA (ID_CSMENA, START_HOUR) VALUES (2, 6);

INSERT INTO dbo.CSMENA (ID_CSMENA, START_HOUR) VALUES (3, 14);

INSERT INTO dbo.CSMENA (ID_CSMENA, START_HOUR) VALUES (4, 22);

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (1, NULL, NULL, NULL, 1, 0, 'P');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (2, NULL, NULL, NULL, 2, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (3, NULL, NULL, NULL, 3, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (4, NULL, NULL, NULL, 4, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (5, NULL, NULL, NULL, 5, 0, 'S');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (6, NULL, NULL, NULL, 6, 0, 'S');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (7, NULL, NULL, NULL, 7, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (8, NULL, NULL, NULL, 8, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (9, NULL, NULL, NULL, 9, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (10, NULL, NULL, NULL, 10, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (11, NULL, NULL, NULL, 11, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (12, NULL, NULL, NULL, 12, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (13, NULL, NULL, NULL, 13, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (14, NULL, NULL, NULL, 14, 0, 'S');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (15, NULL, NULL, NULL, 15, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (16, NULL, NULL, NULL, 16, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (17, NULL, NULL, NULL, 17, 0, 'O');

INSERT INTO dbo.PROSTOJE (ID, ADDR, CC, PARENT, ORD, NA, Kategorie) VALUES (18, NULL, NULL, NULL, 18, 0, 'O');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 16:57:51.0000000', '541240', 'p', '7','2015-07-14 17:00:03.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 17:09:08.0000000', '541240', 'p', '5','2015-07-14 17:09:49.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 17:09:52.0000000', '541240', 'p', '13','2015-07-14 17:17:56.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 18:29:39.0000000', '541240', 'p', '3','2015-07-14 18:34:06.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 18:38:28.0000000', '541240', 'p', '3','2015-07-14 18:40:40.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 18:40:41.0000000', '541240', 'p', '4','2015-07-14 18:45:39.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-15 06:38:25.0000000', '541240', 'p', '3','2015-07-15 06:50:45.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-15 07:57:52.0000000', '541240', 'p', '5','2015-07-15 08:11:54.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-15 10:18:59.0000000', '541240', 'p', '3','2015-07-15 10:23:46.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-15 10:54:12.0000000', '541240', 'p', '3','2015-07-15 10:58:56.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-15 12:31:20.0000000', '541240', 'p', '3','2015-07-15 12:38:24.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 06:15:57.0000000', '541240', 'p', '11','2015-07-16 06:17:26.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 06:38:33.0000000', '541240', 'p', '3','2015-07-16 06:41:29.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 06:43:29.0000000', '541240', 'p', '3','2015-07-16 06:57:16.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 13:11:24.0000000', '541240', 'p', '5','2015-07-13 13:22:15.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 14:10:30.0000000', '541240', 'p', '3','2015-07-13 14:13:41.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 17:14:36.0000000', '541240', 'p', '4','2015-07-13 17:18:11.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 14:54:24.0000000', '541240', 'p', '4','2015-07-14 14:58:55.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 15:13:51.0000000', '541240', 'p', '3','2015-07-14 15:18:23.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 16:28:07.0000000', '541240', 'p', '4','2015-07-14 16:31:35.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 19:54:17.0000000', '541240', 'p', '6','2015-07-14 19:54:43.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 19:54:45.0000000', '541240', 'p', '6','2015-07-14 20:02:40.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-14 20:30:28.0000000', '541240', 'p', '1','2015-07-14 20:40:00.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-15 08:19:59.0000000', '541240', 'p', '3','2015-07-15 09:00:06.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-15 17:30:04.0000000', '541240', 'p', '1','2015-07-15 17:50:11.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 08:29:05.0000000', '541240', 'p', '6','2015-09-02 08:35:27.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 10:04:24.0000000', '541240', 'p', '6','2015-09-02 10:07:32.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 10:18:42.0000000', '541240', 'p', '7','2015-09-02 10:20:41.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 10:37:19.0000000', '541240', 'p', '5','2015-09-02 10:47:46.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 11:21:25.0000000', '541240', 'p', '4','2015-09-02 11:28:58.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 12:44:35.0000000', '541240', 'p', '6','2015-09-02 12:49:56.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 08:26:51.0000000', '541240', 'p', '4','2015-09-02 08:29:05.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 10:26:06.0000000', '541240', 'p', '5','2015-09-02 10:27:10.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 10:27:10.0000000', '541240', 'p', '6','2015-09-02 10:37:18.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 12:29:01.0000000', '541240', 'p', '6','2015-09-02 12:36:37.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 18:42:48.0000000', '541240', 'p', '3','2015-09-02 18:42:57.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 18:56:04.0000000', '541240', 'p', '5','2015-09-02 19:13:16.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 20:30:20.0000000', '541240', 'p', '1','2015-09-02 20:40:46.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 20:50:27.0000000', '541240', 'p', '5','2015-09-02 21:05:07.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 21:07:05.0000000', '541240', 'p', '6','2015-09-02 21:27:46.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 06:20:56.0000000', '541240', 'p', '5','2015-09-03 06:21:07.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 06:21:07.0000000', '541240', 'p', '13','2015-09-03 06:43:00.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 06:56:54.0000000', '541240', 'p', '4','2015-09-03 06:59:24.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 09:22:42.0000000', '541240', 'p', '5','2015-09-03 09:35:20.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 07:34:12.0000000', '541240', 'p', '3','2015-07-16 07:37:20.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 07:39:47.0000000', '541240', 'p', '5','2015-07-16 07:46:00.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 08:09:37.0000000', '541240', 'p', '3','2015-07-16 08:11:36.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 08:12:13.0000000', '541240', 'p', '3','2015-07-16 09:00:10.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 09:00:10.0000000', '541240', 'p', '1','2015-07-16 09:10:05.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-16 09:32:41.0000000', '541240', 'p', '3','2015-07-16 09:47:31.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 16:36:05.0000000', '541240', 'p', '3','2015-07-13 16:39:35.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 16:39:37.0000000', '541240', 'p', '6','2015-07-13 16:43:16.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 17:07:12.0000000', '541240', 'p', '3','2015-07-13 17:12:55.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 17:30:05.0000000', '541240', 'p', '1','2015-07-13 17:50:09.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 18:02:43.0000000', '541240', 'p', '6','2015-07-13 18:04:17.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 18:37:39.0000000', '541240', 'p', '6','2015-07-13 18:43:14.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 19:00:07.0000000', '541240', 'p', '3','2015-07-13 19:02:57.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 19:12:40.0000000', '541240', 'p', '4','2015-07-13 19:20:37.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 19:53:59.0000000', '541240', 'p', '4','2015-07-13 19:58:33.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 19:58:36.0000000', '541240', 'p', '5','2015-07-13 20:08:15.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 20:08:17.0000000', '541240', 'p', '6','2015-07-13 20:11:46.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 20:24:54.0000000', '541240', 'p', '6','2015-07-13 20:26:35.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 20:30:04.0000000', '541240', 'p', '1','2015-07-13 20:40:11.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 20:57:05.0000000', '541240', 'p', '4','2015-07-13 21:12:42.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-07-13 21:45:45.0000000', '541240', 'p', '2','2015-07-13 22:00:11.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 11:18:58.0000000', '541240', 'p', '3','2015-09-03 11:34:01.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 11:34:01.0000000', '541240', 'p', '5','2015-09-03 11:43:55.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 08:12:28.0000000', '541240', 'p', '5','2015-09-02 08:26:51.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 09:00:05.0000000', '541240', 'p', '3','2015-09-02 09:00:07.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 09:00:07.0000000', '541240', 'p', '1','2015-09-02 09:10:02.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 09:16:32.0000000', '541240', 'p', '3','2015-09-02 09:22:10.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 09:48:24.0000000', '541240', 'p', '4','2015-09-02 09:53:17.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 13:13:46.0000000', '541240', 'p', '6','2015-09-02 13:15:41.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 13:42:38.0000000', '541240', 'p', '4','2015-09-02 14:01:37.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 17:30:09.0000000', '541240', 'p', '1','2015-09-02 17:51:15.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 06:12:12.0000000', '541240', 'p', '13','2015-09-03 06:20:56.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 09:00:05.0000000', '541240', 'p', '1','2015-09-03 09:10:23.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 10:36:41.0000000', '541240', 'p', '4','2015-09-03 10:42:08.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 11:11:33.0000000', '541240', 'p', '7','2015-09-03 11:18:58.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 12:32:22.0000000', '541240', 'p', '4','2015-09-03 12:38:46.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 13:52:12.0000000', '541240', 'p', '4','2015-09-03 13:55:01.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 13:55:01.0000000', '541240', 'p', '4','2015-09-03 14:02:28.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 14:16:10.0000000', '541240', 'p', '3','2015-09-03 14:21:52.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 16:00:34.0000000', '541240', 'p', '5','2015-09-03 16:11:51.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 16:20:32.0000000', '541240', 'p', '6','2015-09-03 16:22:41.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 12:41:50.0000000', '541240', 'p', '7','2015-09-02 12:44:35.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 12:52:35.0000000', '541240', 'p', '1','2015-09-02 12:52:37.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 12:52:37.0000000', '541240', 'p', '7','2015-09-02 12:58:22.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 14:19:53.0000000', '541240', 'p', '6','2015-09-02 14:44:13.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 16:38:44.0000000', '541240', 'p', '5','2015-09-02 17:01:54.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 17:01:57.0000000', '541240', 'p', '3','2015-09-02 17:15:17.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 19:25:19.0000000', '541240', 'p', '3','2015-09-02 19:37:27.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-02 19:56:47.0000000', '541240', 'p', '4','2015-09-02 19:59:23.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 14:45:41.0000000', '541240', 'p', '3','2015-09-03 14:49:19.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 16:51:51.0000000', '541240', 'p', '3','2015-09-03 16:55:06.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 17:58:16.0000000', '541240', 'p', '3','2015-09-03 18:06:04.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 18:06:26.0000000', '541240', 'p', '3','2015-09-03 18:32:40.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 18:32:40.0000000', '541240', 'p', '5','2015-09-03 18:44:27.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 18:48:52.0000000', '541240', 'p', '3','2015-09-03 18:54:37.0000000');

INSERT INTO dbo.Events (TIME, ARBPLNR, TYPE, _KEY, TIME2) VALUES ('2015-09-03 18:59:17.0000000', '541240', 'p', '3','2015-09-03 19:09:04.0000000');

EDIT: Plans moved into attachements

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

How to Post Performance Problems[/url]

By Gail Shaw

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2