CIO Tech Eksperten IT-JOB IT-Kurser Events Podcast Søg
Cookie ikon
Avatar billede anders_cp Nybegynder
18. maj 2008 - 16:27 Der er 14 kommentarer og
1 løsning

Tilretning af sql (fra start-række til felt)

Hej
Jeg har fået kreeret en sql godt hjulpet af Design Query - editoren.
Det er ikke helt det ønskede, så jeg vil have noget hjælp til at finde den rigtige sql. Her følger en forklaring:
Hver aktivitet har flere activitydetail. F.eks. kan aktivitet 500 se således ud:
aID  act.detailID  statusID  datetime
c)500  1000          20          2008-04-28
500    1001          19          2008-04-28
500    1002          10          2008-04-28
a)500  1003          26          2008-05-02
b)500  1004          19          2008-05-15
500    1005          21          2008-05-15

Min sql finder aktiviter som er over 9 dage fra a) til b)
Jeg søger derimod fra c) til b), altså den første i rækken til den næste efter status 26. Håber I kan hjælpe mig med dette, evt. ved at tilrette den sql jeg allerede har kommet frem til som finder dagene fra a) til b)

Her er min foreløbige sql:
SELECT
    T3.ActivityID,
    T4.TimeStamp AS FirstDateTimeStamp,
    T5.TimeStamp AS NextDateTimeStamp,
    T4.QueueName AS Technican,
    DATEDIFF(dd, T4.TimeStamp, T5.TimeStamp) AS Days
FROM       
    ActivityDetailsAll AS T4 INNER JOIN
        (SELECT
            T1.ActivityID,
            MIN(T2.ActivityDetailID) AS FirstActivityDetailID,
            MIN(T1.ActivityDetailID) AS NextActivityDetailID
        FROM         
            ActivityDetailsAll AS T1 INNER JOIN
            (SELECT
                ActivityID,
                MAX(ActivityDetailID) AS ActivityDetailID
            FROM         
            ActivityDetailsAll
            WHERE     
            (TimeStamp BETWEEN '2008-05-01' AND '2008-05-31') AND (StatusID = 26)
              GROUP BY
                  ActivityID, ActivityDetailID) AS T2 ON T1.ActivityID = T2.ActivityID
                  AND T1.ActivityDetailID > T2.ActivityDetailID
              GROUP BY T1.ActivityID) AS T3 ON T3.FirstActivityDetailID = T4.ActivityDetailID
              INNER JOIN
              ActivityDetails AS T5 ON T3.NextActivityDetailID = T5.ActivityDetailID
                WHERE   
                (DATEDIFF(dd, T4.TimeStamp, T5.TimeStamp) > 9)
 

Hilsen Anders
Avatar billede janus_007 Nybegynder
18. maj 2008 - 17:23 #1
Er statusid 26 altid gældende?
Kan der være mere en en række efter den fundne?
Avatar billede anders_cp Nybegynder
18. maj 2008 - 17:41 #2
StatusID 26 er altid gældende forstået på den måde at de poster uden statusID ikke er interessante. Jeg ønsker:
DateTime fra = første post (eksemplet: activitydetailid = 1000)
DateTime til = posten efter statusID=26 (eksemplet: activitydetailid = 1004)
Antal dage i eksemplet: 15-5 - 28-4 = 17 dage
Avatar billede anders_cp Nybegynder
18. maj 2008 - 17:47 #3
Kan der være mere en en række efter den fundne?

nr. et er altid nummer et. Måske løses v.hj.a. denne:
SELECT MIN(activitydetailid)FROM ActivityDetailsAll

og ja, der kan være mere end en række efter det fundne. Et eksempel kunne være:
a) 20
b) 19
c) 10
d) 26
e) 19
f) 21
g) 26
h) 11
i) 23
I dette tilfælde ønskes
a) til e)
og
a) til h)

For overblikkets skyld er statusID = 26 en status for at reservedel ankommer.
Avatar billede anders_cp Nybegynder
19. maj 2008 - 15:56 #4
Kan følgende være en hjælp?

CREATE TABLE TESTActivityDetailsAll(
ActivityDetailID    INT    IDENTITY(1,1)    PRIMARY KEY CLUSTERED,
ActivityID            INT            NOT NULL,
StatusID            SMALLINT    NOT NULL,
[TimeStamp]            DATETIME    NOT NULL,
)



SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857534,205541,26,'2008-05-08 08:15:34.090') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857535,204440,26,'2008-05-08 08:15:44.650') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857536,205795,7,'2008-05-08 08:15:51.043') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857537,205795,7,'2008-05-08 08:16:07.230') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857538,204723,26,'2008-05-08 08:17:16.497') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857539,205540,26,'2008-05-08 08:17:30.683') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857540,205752,26,'2008-05-08 08:17:41.530') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857541,205768,26,'2008-05-08 08:17:50.997') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857542,205694,26,'2008-05-08 08:18:00.013') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857543,205637,26,'2008-05-08 08:18:15.670') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857544,205046,26,'2008-05-08 08:18:48.247') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857545,205105,26,'2008-05-08 08:19:02.373') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857546,205557,19,'2008-05-08 08:19:50.810') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857547,205557,10,'2008-05-08 08:20:53.110') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857548,205796,17,'2008-05-08 08:21:51.983') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857549,205424,19,'2008-05-08 08:22:20.830') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857550,205797,17,'2008-05-08 08:23:00.860') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857551,204915,10,'2008-05-08 08:24:56.500') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857552,205603,10,'2008-05-08 08:26:01.223') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857553,205564,26,'2008-05-08 08:26:27.880') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857554,204440,19,'2008-05-08 08:27:18.067') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857555,205590,26,'2008-05-08 08:28:47.973') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857556,205732,19,'2008-05-08 08:29:19.193') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857557,205589,26,'2008-05-08 08:29:41.693') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857558,204833,10,'2008-05-08 08:30:18.757') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857559,205569,26,'2008-05-08 08:30:30.117') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857560,205321,26,'2008-05-08 08:31:41.900') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857561,205773,19,'2008-05-08 08:33:06.150') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857562,205534,26,'2008-05-08 08:33:17.447') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857563,205466,26,'2008-05-08 08:34:53.713') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857564,205728,26,'2008-05-08 08:35:39.073') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857565,205329,7,'2008-05-08 08:36:07.900') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857566,205136,26,'2008-05-08 08:36:52.857') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857567,205307,26,'2008-05-08 08:37:20.230') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857568,205754,13,'2008-05-08 08:37:50.887') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857569,205754,13,'2008-05-08 08:38:23.043') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857570,205521,26,'2008-05-08 08:39:39.967') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857571,205631,19,'2008-05-08 08:40:11.060') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857572,205631,21,'2008-05-08 08:40:28.030') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857573,205571,26,'2008-05-08 08:40:44.310') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857574,205438,26,'2008-05-08 08:41:22.670') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857575,205400,26,'2008-05-08 08:42:33.250') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857576,205702,19,'2008-05-08 08:43:51.690') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857577,205702,4,'2008-05-08 08:43:55.440') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857578,205754,4,'2008-05-08 08:44:08.190') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857579,205389,19,'2008-05-08 08:44:31.190') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857580,205435,10,'2008-05-08 08:47:24.287') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857581,205215,19,'2008-05-08 08:50:09.263') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857582,205682,21,'2008-05-08 08:52:50.577') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857583,205424,21,'2008-05-08 08:56:27.690') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857584,204493,19,'2008-05-08 08:56:37.173') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857585,205215,10,'2008-05-08 08:57:15.003') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857586,205701,19,'2008-05-08 08:57:17.393') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857587,205575,13,'2008-05-08 08:57:17.737') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857588,205575,17,'2008-05-08 08:57:22.363') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857589,205701,19,'2008-05-08 08:59:53.583') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857590,205798,27,'2008-05-08 09:00:32.130') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857591,205798,10,'2008-05-08 09:01:55.553') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857592,205729,10,'2008-05-08 09:05:38.540') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857593,205773,19,'2008-05-08 09:06:10.133') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857594,205488,10,'2008-05-08 09:07:06.497') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857595,205486,19,'2008-05-08 09:07:36.790') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857596,205514,19,'2008-05-08 09:07:43.057') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857597,205513,19,'2008-05-08 09:07:50.120') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857598,205799,20,'2008-05-08 09:09:06.167') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857599,205800,20,'2008-05-08 09:09:14.760') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857600,205683,21,'2008-05-08 09:09:17.247') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857601,205763,19,'2008-05-08 09:09:41.810') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857602,203688,19,'2008-05-08 09:09:54.323') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857603,205801,17,'2008-05-08 09:09:55.060') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857604,205800,19,'2008-05-08 09:10:02.373') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857605,205800,10,'2008-05-08 09:10:17.357') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857606,205700,19,'2008-05-08 09:11:11.107') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857607,205800,13,'2008-05-08 09:11:12.357') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857608,205763,19,'2008-05-08 09:12:32.937') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857609,205453,4,'2008-05-08 09:13:03.123') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857610,205453,10,'2008-05-08 09:13:53.563') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857611,205763,19,'2008-05-08 09:19:16.440') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857612,203304,19,'2008-05-08 09:19:34.880') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857613,205731,20,'2008-05-08 09:24:38.697') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857614,205731,19,'2008-05-08 09:24:42.587') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857615,205731,10,'2008-05-08 09:24:46.010') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857616,205700,19,'2008-05-08 09:30:01.730') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857617,205643,4,'2008-05-08 09:31:03.653') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857618,205641,19,'2008-05-08 09:32:42.000') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857619,205641,21,'2008-05-08 09:32:52.327') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857620,205710,19,'2008-05-08 09:34:17.170') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857621,205459,19,'2008-05-08 09:34:18.360') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857622,205670,10,'2008-05-08 09:34:31.873') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857623,205543,21,'2008-05-08 09:36:07.940') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857624,205459,21,'2008-05-08 09:37:09.533') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857625,203688,21,'2008-05-08 09:37:27.003') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857626,205802,20,'2008-05-08 09:38:45.050') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857627,202711,19,'2008-05-08 09:39:30.410') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857628,204218,19,'2008-05-08 09:40:21.863') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857629,205803,17,'2008-05-08 09:41:59.507') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857630,204440,21,'2008-05-08 09:43:09.680') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857631,205804,20,'2008-05-08 09:43:33.367') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857632,197838,19,'2008-05-08 09:44:31.210') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857633,205514,21,'2008-05-08 09:46:09.650') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857634,205513,21,'2008-05-08 09:46:47.180') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857635,205704,19,'2008-05-08 09:47:39.993') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857636,205705,19,'2008-05-08 09:48:03.713') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857637,205429,21,'2008-05-08 09:49:33.957') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857638,205647,27,'2008-05-08 09:50:46.737') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857639,205647,27,'2008-05-08 09:51:00.830') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857640,205647,10,'2008-05-08 09:51:25.440') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857641,205783,20,'2008-05-08 09:51:29.753') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857642,205352,19,'2008-05-08 09:54:12.257') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857643,205442,7,'2008-05-08 09:54:41.223') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857644,205778,19,'2008-05-08 09:56:59.523') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857645,205486,21,'2008-05-08 09:57:25.917') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857646,205322,10,'2008-05-08 09:57:52.243') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857647,205805,20,'2008-05-08 09:58:20.320') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857648,205716,19,'2008-05-08 10:00:03.307') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857649,204760,4,'2008-05-08 10:00:05.730') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857650,205706,19,'2008-05-08 10:00:35.510') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857651,205794,7,'2008-05-08 10:01:23.760') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857652,205795,7,'2008-05-08 10:01:51.887') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857653,197838,21,'2008-05-08 10:03:07.387') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857654,204218,21,'2008-05-08 10:04:42.450') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857655,205806,20,'2008-05-08 10:04:54.903') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857656,205406,19,'2008-05-08 10:05:21.547') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857657,205778,10,'2008-05-08 10:05:27.953') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857658,204480,19,'2008-05-08 10:05:35.013') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857659,205334,19,'2008-05-08 10:05:42.327') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857660,205807,20,'2008-05-08 10:09:18.220') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857661,205620,20,'2008-05-08 10:09:21.410') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857662,205620,19,'2008-05-08 10:09:25.737') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857663,205808,20,'2008-05-08 10:10:24.660') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857664,205620,10,'2008-05-08 10:10:27.220') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857665,205808,19,'2008-05-08 10:12:01.427') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857666,205808,21,'2008-05-08 10:12:08.990') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857667,205809,17,'2008-05-08 10:12:09.660') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857668,205462,19,'2008-05-08 10:12:57.410') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857669,205810,20,'2008-05-08 10:14:18.803') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857670,204480,21,'2008-05-08 10:15:07.193') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857671,205701,19,'2008-05-08 10:15:33.680') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857672,205175,19,'2008-05-08 10:16:03.290') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857673,205623,10,'2008-05-08 10:18:05.790') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857674,205811,17,'2008-05-08 10:18:52.540') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857675,205233,10,'2008-05-08 10:19:15.400') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857676,204828,19,'2008-05-08 10:19:44.777') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857677,205812,20,'2008-05-08 10:20:39.027') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857678,205813,13,'2008-05-08 10:21:42.497') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857679,205812,20,'2008-05-08 10:22:12.027') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857680,205323,19,'2008-05-08 10:22:27.730') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857681,204976,19,'2008-05-08 10:25:03.810') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857682,205477,19,'2008-05-08 10:25:55.030') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857683,205477,21,'2008-05-08 10:26:04.483') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857684,202711,21,'2008-05-08 10:26:53.907') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857685,205814,20,'2008-05-08 10:27:13.627') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857686,205700,19,'2008-05-08 10:27:34.610') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857687,205815,20,'2008-05-08 10:27:51.483') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857688,205323,21,'2008-05-08 10:28:11.033') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857689,205816,13,'2008-05-08 10:28:25.940') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857690,205466,19,'2008-05-08 10:28:31.593') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857691,205817,20,'2008-05-08 10:30:00.393') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857692,205657,20,'2008-05-08 10:30:48.223') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857693,205478,19,'2008-05-08 10:30:56.020') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857694,205478,21,'2008-05-08 10:31:04.597') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857695,200236,19,'2008-05-08 10:32:02.363') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857696,205580,20,'2008-05-08 10:32:06.440') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857697,205818,17,'2008-05-08 10:32:22.550') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857698,205136,19,'2008-05-08 10:32:41.817') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857699,205662,20,'2008-05-08 10:33:45.897') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857700,200236,21,'2008-05-08 10:33:48.630') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857701,205819,6,'2008-05-08 10:34:26.460') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857702,205718,20,'2008-05-08 10:35:08.803') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857703,205819,6,'2008-05-08 10:35:16.537') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857704,205701,19,'2008-05-08 10:37:37.337') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857705,205722,19,'2008-05-08 10:37:47.367') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857706,204976,19,'2008-05-08 10:38:45.697') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857707,205406,21,'2008-05-08 10:38:50.977') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857708,204976,10,'2008-05-08 10:39:18.010') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857709,205820,17,'2008-05-08 10:39:24.603') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857710,205471,19,'2008-05-08 10:39:35.807') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857711,205757,19,'2008-05-08 10:40:16.980') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857712,204723,19,'2008-05-08 10:43:36.310') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857713,205718,20,'2008-05-08 10:43:38.120') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857714,204983,19,'2008-05-08 10:44:39.700') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857715,205757,19,'2008-05-08 10:45:01.950') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857716,205821,7,'2008-05-08 10:46:02.170') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857717,205722,10,'2008-05-08 10:46:43.593') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857718,205466,21,'2008-05-08 10:47:06.217') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857719,205216,4,'2008-05-08 10:47:28.687') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857720,205423,19,'2008-05-08 10:47:34.170') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857721,205822,20,'2008-05-08 10:47:42.140') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857722,205590,19,'2008-05-08 10:48:09.093') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857723,205823,17,'2008-05-08 10:48:30.753') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857724,205141,4,'2008-05-08 10:50:17.107') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857725,204983,4,'2008-05-08 10:51:16.450') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857726,205824,20,'2008-05-08 10:53:06.780') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857727,204509,19,'2008-05-08 10:56:55.987') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857728,205825,17,'2008-05-08 11:00:01.893') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857729,205726,26,'2008-05-08 11:01:44.227') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857730,205729,26,'2008-05-08 11:02:50.897') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857731,205117,19,'2008-05-08 11:03:11.960') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857732,205698,26,'2008-05-08 11:03:13.100') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857733,205136,21,'2008-05-08 11:03:45.057') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857734,205727,26,'2008-05-08 11:03:56.413') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857735,205400,19,'2008-05-08 11:05:48.993') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857736,205419,20,'2008-05-08 11:07:39.777') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857737,205471,19,'2008-05-08 11:07:40.150') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857738,205471,21,'2008-05-08 11:07:51.340') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857739,205400,19,'2008-05-08 11:09:17.403') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857740,205826,27,'2008-05-08 11:09:48.480') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857741,205826,27,'2008-05-08 11:10:16.263') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857742,205826,10,'2008-05-08 11:12:57.593') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857743,204732,20,'2008-05-08 11:16:04.110') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857744,205827,20,'2008-05-08 11:17:01.503') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857745,204732,20,'2008-05-08 11:17:13.190') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857746,205105,19,'2008-05-08 11:18:20.783') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857747,204509,21,'2008-05-08 11:18:21.740') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857748,205321,19,'2008-05-08 11:19:14.037') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857749,205827,20,'2008-05-08 11:21:21.960') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857750,205634,20,'2008-05-08 11:21:39.787') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857751,205634,20,'2008-05-08 11:21:59.443') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857752,205468,19,'2008-05-08 11:25:20.603') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857753,205796,5,'2008-05-08 11:28:01.683') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857754,205400,19,'2008-05-08 11:28:14.323') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857755,205797,5,'2008-05-08 11:28:17.700') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857756,205716,19,'2008-05-08 11:28:36.700') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857757,205801,5,'2008-05-08 11:29:00.997') SET IDENTITY_INSERT TESTActivityDetailsAll OFF
SET IDENTITY_INSERT TESTActivityDetailsAll ON INSERT INTO TESTActivityDetailsAll(ActivityDetailID, ActivityID, StatusID, TimeStamp) VALUES(857758,205400,21,'2008-05-08 11:29:33.387') SET IDENTITY_INSERT TESTActivityDetailsAll OFF


min sql:
SELECT
    T3.ActivityID,
    T4.TimeStamp AS FirstDateTimeStamp,
    T5.TimeStamp AS NextDateTimeStamp,

    DATEDIFF(dd, T4.TimeStamp, T5.TimeStamp) AS Days
FROM       
    TESTActivityDetailsAll AS T4 INNER JOIN
        (SELECT
            T1.ActivityID,
            MIN(T2.ActivityDetailID) AS FirstActivityDetailID,
            MIN(T1.ActivityDetailID) AS NextActivityDetailID
        FROM         
            TESTActivityDetailsAll AS T1 INNER JOIN
            (SELECT
                ActivityID,
                MAX(ActivityDetailID) AS ActivityDetailID
            FROM         
            TESTActivityDetailsAll
            WHERE     
            (TimeStamp BETWEEN '2008-05-01' AND '2008-05-31') AND (StatusID = 26)
              GROUP BY
                  ActivityID, ActivityDetailID) AS T2 ON T1.ActivityID = T2.ActivityID
                  AND T1.ActivityDetailID > T2.ActivityDetailID
              GROUP BY T1.ActivityID) AS T3 ON T3.FirstActivityDetailID = T4.ActivityDetailID
              INNER JOIN
              TESTActivityDetailsAll AS T5 ON T3.NextActivityDetailID = T5.ActivityDetailID
                WHERE   
                (DATEDIFF(dd, T4.TimeStamp, T5.TimeStamp) > 9)
Avatar billede janus_007 Nybegynder
19. maj 2008 - 16:51 #5
Ja jeg vil gerne hjælpe dig, men umiddelbart kommer vi nok ud i noget med en cursor.
Tak for det testdata du har postet, det gør altid sådan en opgave nemmere, men jeg forstår ikke helt... alle rækker er på samme dato?
Avatar billede anders_cp Nybegynder
19. maj 2008 - 22:28 #6
Det ville være helt fantastisk vis du kunne hjælpe mig(!), cursor eller ej
Maj md. fylder 1000 linier, så jeg har ikke kunne poste den her, men du kan hente tre filer her:
www.servicepartner.dk/Janus/Jagten.rar

1) table-create
2) insert statements
3) min sql (som ikke giver det rigtige)
Avatar billede janus_007 Nybegynder
20. maj 2008 - 00:46 #7
Hey.. Nåh.. nu har jeg siddet og fiflet lidt. Jeg tænker du måske selv lige smide datediffen ind, jeg forstår ikke helt hvad den betyder.

Jeg har lavet det med en cursor, jeg tager udgangspunkt i minimum ActivityDetailID og for hver Activity leder jeg så fra den minimum og frem til laveste ActivityDetailID lige efter StatusID = 26

Så eks.vis for ActivityID = 203631 vil jeg få flg.
1    854281    204631    10    2008-04-30 05:21:21.020
1    855046    204631    26    2008-05-02 08:08:15.617
1    855342    204631    19    2008-05-02 13:15:56.180
2    854281    204631    10    2008-04-30 05:21:21.020
2    855046    204631    26    2008-05-02 08:08:15.617
2    855342    204631    19    2008-05-02 13:15:56.180
2    855643    204631    10    2008-05-05 08:50:05.917
2    855988    204631    10    2008-05-05 13:53:18.383
2    857107    204631    26    2008-05-07 10:41:22.030
2    857381    204631    19    2008-05-07 15:12:17.480

Den første kolonne er en SequenceID som jeg har indført for at se de forskellige sekvenser fra start og til første 26 (+1)og igen fra start og til den efterfølgende 26 (+1) osv.

Her er cursorfunktionen, til at teste har jeg sat en where-clause ind med ActivityID = 203631



DECLARE curRunningActivity
CURSOR LOCAL FAST_FORWARD FOR
    select min(a.ActivityDetailID) as ActivityDetailID_Start, a.ActivityID
        , p.ActivityDetailID

        from  TESTActivityDetailsAll a
    inner join (
            select ActivityID, ActivityDetailID from TESTActivityDetailsAll i
                where StatusID = 26 -- jeg tror du skal tilføje noget datostyring her.. er nemlig ikke helt sikker :-|
                group by ActivityID, ActivityDetailID) as p
    on p.ActivityID = a.ActivityID
where a.ActivityID = 204631
    group by a.ActivityID, p.ActivityDetailID
    order by a.ActivityID, p.ActivityDetailID


OPEN curRunningActivity

DECLARE @ActivityDetailID_Start INT
DECLARE @ActivityID int
DECLARE @ActivityDetailID int
DECLARE @SequenceID int
DECLARE @PreviousID int

set @PreviousID = 0
set @SequenceID = 0

DECLARE @Result TABLE
(
SequenceID int,
ActivityDetailID INT,
ActivityID int,
StatusID int,
[TimeStamp] datetime
)

FETCH NEXT FROM curRunningActivity
INTO @ActivityDetailID_Start, @ActivityID, @ActivityDetailID

WHILE @@FETCH_STATUS = 0
BEGIN

if @ActivityID != @previousID
    set @SequenceID = 0

    set @SequenceID = @SequenceID + 1

insert @Result
select @SequenceID, * from TESTActivityDetailsAll
where ActivityDetailID between @ActivityDetailID_Start and
        (select min(ActivityDetailID)  from TESTActivityDetailsAll
            where ActivityID = @ActivityID
            and ActivityDetailID > @ActivityDetailID)
        and ActivityID = @ActivityID

set @previousID = @ActivityID


FETCH NEXT FROM curRunningActivity
INTO @ActivityDetailID_Start, @ActivityID, @ActivityDetailID
END

CLOSE curRunningActivity
DEALLOCATE curRunningActivity

SELECT * FROM @Result --< denne skal medtages i samme batch som do.!! ellers skal du bruge et #table :)

Håber du kan komme videre med det, det er sku noget af noget businesslogic hehe.
Avatar billede anders_cp Nybegynder
20. maj 2008 - 08:30 #8
Jeg er bange for jeg ikke har forklaret mig ordenligt, så det prøver jeg her:

Systemet blive brugt på et værksted til rep. af computere


a) 853187          205372          20                  2008-04-28 12:29:50.627

853465          205372          19                  2008-04-28 19:27:05.383

853466          205372          10                  2008-04-28 19:27:09.180

b) 855032          205372          26                  2008-05-02 08:04:58.143

c) 860439          205372          19                  2008-05-15 10:43:09.580

860685          205372          21                  2008-05-15 14:27:06.670
Ovenstående viser aktiviteten for en rep med activityID=205372.
853187 to 860685 er numrene for detaljerne omkring en rep. Fra start til slut.  statusID=26 er kun interessant i denne sag. StatusID=26 indikerer at en tekniker har modtaget nogle reservedel til en computer (ex. et soundcard). Der kan godt modtages flere reservedele, men kun en tilfældene skal vises, selvom begge eller flere gælder.
Hvis du kører min test-query får du følgende output:
205372 2008-05-02 08:04:58.143 2008-05-15 10:43:09.580 13
205375 2008-05-06 08:10:51.777 2008-05-16 14:03:29.580 10
Outputtet for activityID 205372 (row1) viser intervallet fra a) til b) som er 13 dage.

Imdidlertid ønsker jeg outputtet fra START til status lige efter StatutID=26, som er fra  a) til c):
28.april to 15.may: 17  days.
Jeg vil ønsker (mig meget :-) ) activities, som er over 9 dage fra start til statusID lige efter statusID=26.

Håber du stadig er hooked på at hjælpe mig ;)
hilsen
Anders
Avatar billede janus_007 Nybegynder
20. maj 2008 - 18:04 #9
hmm mjaa mjoo den er ved at trænge ind, dvs. du vil have en 2 datoer ud i samme række, fra en reservedel er modtaget til der er sket noget i sagen? (og så eks.vis med mere end 9 dages mellemrum)

Er det korrekt?
Avatar billede anders_cp Nybegynder
20. maj 2008 - 18:09 #10
jo det er 95% korrekt. Jeg havde oprindeligt lavet det sådan som du beskriver altså

b)-reservedel kommet = statusid 26 til
der sker noget
c) status skifter = sker noget.

Men det skal være fra start a) og til der sker noget c)

Dine andre betragtninger er korrekte :-)
Avatar billede janus_007 Nybegynder
20. maj 2008 - 18:34 #11
Okay, det må jeg altså lige ha bøjet i neonrør så...

Jeg tager udgangspunkt i :

a) 853187          205372          20                  2008-04-28 12:29:50.627
853465          205372          19                  2008-04-28 19:27:05.383
853466          205372          10                  2008-04-28 19:27:09.180
b) 855032          205372          26                  2008-05-02 08:04:58.143
c) 860439          205372          19                  2008-05-15 10:43:09.580
860685          205372          21                  2008-05-15 14:27:06.670

Her vil du gerne have:
205372 2008-05-02 08:04:58.143 2008-05-15 10:43:09.580 13

Fordi der er mere end 9 dage fra start a) til c) 19 og derfor vil du gerne vise  b) 26 og c) 19?
Avatar billede anders_cp Nybegynder
20. maj 2008 - 18:41 #12
Du skriver fra b) til c) (som jeg selv først troede det var - virker mest naturligt), men det jeg vil have er
fra a) til c)
2008-04-28 12:29:50.627    2008-05-15 10:43:09.580
som giver 17 dage.
Fordi der er mere end 9 dage fra start a) til c)
Avatar billede anders_cp Nybegynder
21. maj 2008 - 21:44 #13
Har du givet op, eller prøver du at finde en løsning?
Avatar billede anders_cp Nybegynder
22. maj 2008 - 00:41 #14
Jeg har fundet en løsning som ser sådan ud:
SELECT b.ActivityID, a.firsttime, c.TimeStamp,
      datediff(DAY, a.firsttime, c.TimeStamp)
FROM  (SELECT ActivityID, firsttime = MIN(TimeStamp)
      FROM  TESTActivityDetailsAll
      GROUP  BY ActivityID) AS a
JOIN  (SELECT ActivityID, stat26time = MIN(TimeStamp)
      FROM  TESTActivityDetailsAll
      WHERE  StatusID = 26
      GROUP  BY ActivityID
      HAVING MIN(TimeStamp) BETWEEN '20080501' AND '20080531') AS b
      ON a.ActivityID = b.ActivityID
JOIN  TESTActivityDetailsAll c
      ON a.ActivityID = c.ActivityID
      AND c.TimeStamp = (SELECT MIN(d.TimeStamp)
                        FROM  TESTActivityDetailsAll d
                        WHERE  d.ActivityID = b.ActivityID
                          AND  d.TimeStamp > b.stat26time)
WHERE  datediff(DAY, b.stat26time, c.TimeStamp) > 9

Jeg vil gerne takke dig for alt det besvær du har haft ved at hjælpe mig.
Avatar billede janus_007 Nybegynder
26. maj 2008 - 01:29 #15
Super... ja jeg har været lidt fraværende pga. mit job. Lækkert du fik løst opgaven.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Database management kurser
Computerworld tilbyder specialiserede kurser i database-management
Se alle Database management kurser

Flere spørgsmål fra MS SQL kategorien

Titel Indlæg Oprettet Seneste aktivitet
Danske karakterter i simpel insert Af boris i MS SQL 2 25/04/202414:05 29/04/202411:41
Kan ikke connecte til sql serveren Af simsen i MS SQL 2 05/01/202417:02 05/01/202420:51
Count med NOT IN og 2 conditions Af sorenmt84 i MS SQL 2 08/11/202308:37 08/11/202310:32
Top X af group Af totalpc i MS SQL 1 18/10/202321:23 09/11/202313:08
Row level security på flere kolonner Af dane022 i MS SQL 8 30/08/202321:28 01/09/202300:55
Se alle spørgsmål i kategorien Opret spørgsmål

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Opret Log ind

Du kan også logge ind via nedenstående tjenester



Alle kategorier på Eksperten
IT-JOB

Udlændinge- og Integrationsministeriet

Generalist med interesse for it-økonomistyring søges til Udlændingestyrelsen

Udviklings- og Forenklingsstyrelsen

Erfaren teamleder til årsopgørelsen

Unik System Design A/S

Head of Internal IT

Udviklings- og Forenklingsstyrelsen

Kodestærk og erfaren DevOps-udvikler til ambitiøst app-kontor

De Nationale Geologiske Undersøgelser for Danmark og Grønland (GEUS)

IT-systemadministrator søges til GEUS
Seneste spørgsmål Seneste aktivitet
I går 16:51 UNILOGIN i GOOGLE Af lao i Browsere
I går 10:07 Kan det gøres lettere Af densortehingst i Excel
01/0821:49 En app vækker mig om morgenen og giver en vejrudsigt - hvordan stoppe det? Af Philip Kuhlmann i Apps til Android
01/0821:28 visning af heltal som resultat efter beregning Af Brian_Skovgaard i Excel
01/0814:48 Microsoft Business - kan ikke logge ind Af Lasse i Office & Kontorpakker
White papers
Flere white papers »


Premium
Teaser billede
Nvidia efterforskes for brud på konkurrencelov
Læs mere »
Den store cloud-krig raser stadigvæk - og Amazon ser lige nu ud til at have overhånden
Apple præsenter første regnskab siden AI-udmelding: Her er tre bemærkelsesværdige pointer derfra
Sårbarhed kan let give administratorrettigheder til alle: Udnyttes allerede af ransomware-grupper
Se alle »
Computerworld
Teaser billede
Første test: Denne helt nye wunder-CPU vil du have i din næste laptop
Læs mere »
Alvorlig fejl i Intel-chips breder sig: Listen over ramte processor vokser og vokser – og de kan blive permanent beskadigede
’Apple Intelligence’ slippes løs: Her kommer første mulighed for at afprøve Apples kunstige intelligens
Flere statslige it-løsninger ramt af netværksproblemer - ansatte kunne ikke få mail-adgang
Se alle »
CIO
Teaser billede
Stor aftale gør Microsofts datacentre hurtigere - investerer i netværksudstyr
Læs mere »
Telenor skrotter ældre it-system: Nyt system er en hyldevare
Derfor står Danske Bank foran en kæmpe AWS-transformation: Ellers skulle vi bygge en ny infrastruktur for at følge med
NIS2 i Danmark udskydes med flere måneder: Her er den nye dato, hvor loven træder i kraft
Se alle »
Job & Karriere
Teaser billede
Efter 12 år er NNIT's hovedkvarter i Søborg nu ryddet og tomt - alle arbejder hjemme: "Det er med et vist vemod"
Læs mere »
KMD-direktør forlader selskabet: Det skal hun nu
Dansk top-profil trækker sig fra Microsoft: Skal være direktør i TDC Erhverv
IBM Danmark skifter ud i sin øverste ledelse - her er den nye direktion
Se alle »
White paper
Teaser billede
Sådan gør du: Elektronisk dokumentudveksling i praksis
Læs mere »
Sådan høster du forretningsfordelene ved Internet of Things
Vejen væk fra WAN: Sådan skifter du til en moderne infrastruktur
Sådan får du overblik og beskytter dine cloudapplikationer
Se alle »

Events
Flere events »
White papers
Flere white papers »
IT-Kurser
Se alle vores it-kurser »