create table act_log(

[id] [int] NOT NULL,
[persid] [nvarchar](30) NULL,
[analyst] [binary](16) NULL,
[action_desc] [ntext] NULL,
[type] [nvarchar](30) NULL,
[time_stamp] [int] NULL,
[call_req_id] [nvarchar](30) NULL,
);

Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400003,'alg:400003',0x74BD5CD16C2AF7429341803E2DF1DCC3,'Contact: Brown, June  Phone: +1-7153335592 Email: jbrown@ca.com','INIT',1657132266,'cr:400002');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400004,'alg:400004',0x74BD5CD16C2AF7429341803E2DF1DCC3,'log a user comment','LOG',1657132266,'cr:400002');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400005,'alg:400005',0x496C97AD4F0F1149A32BF0256EB7396A,'''Transfer Assignee from '' to'' ''Smith, Kevin '' ' ,'TR',1657132331,'cr:400002');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400006,'alg:400006',0x496C97AD4F0F1149A32BF0256EB7396A,'Status changed from ''Open'' to ''Hold''','ST',1657132433,'cr:400002');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400007,'alg:400007',0x496C97AD4F0F1149A32BF0256EB7396A,'The Service Type(s) on a ticket were delayed','SLADELAY',1657132440,'cr:400002');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400008,'alg:400008',0x496C97AD4F0F1149A32BF0256EB7396A,'Status changed from ''Hold'' to ''Open''','ST',1657132683,'cr:400002');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400009,'alg:400009',0x496C97AD4F0F1149A32BF0256EB7396A,'The Service Type(s) on the ticket were resumed','SLARESUME',1657132689,'cr:400002');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400010,'alg:400010',0x496C97AD4F0F1149A32BF0256EB7396A,'Status changed from ''Open'' to ''Acknowledged''','ST',1657132880,'cr:400002');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400011,'alg:400011',0x496C97AD4F0F1149A32BF0256EB7396A,'Status changed from ''Acknowledged'' to ''In Progress''','ST',1657133436,'cr:400002');

Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400051,'alg:400051',0x74BD5CD16C2AF7429341803E2DF1DCC3,'Contact: Brown, June  Phone: +1-7153335592 Email: jbrown@ca.com','INIT',1657616465,'cr:400051');

Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400052,'alg:400052',0x74BD5CD16C2AF7429341803E2DF1DCC3,'log a user comment','LOG',1657616465,'cr:400051');
Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400053,'alg:400053',0xB07A9D09C93D294E919C61B616A5C07E,'''Transfer Assignee from '' to'' ''Bell, Donald '' ','TR',1657616553,'cr:400051');

Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400055,'alg:400055',0x93F557073BC21F43AE736D0A6FE1FDD2,'Status changed from ''Open'' to ''Acknowledged''','ST',1657617136,'cr:400051');

Insert into act_log (id,persid,analyst,action_desc,type,time_stamp,call_req_id)
VALUES (400101,'alg:400101',0x93F557073BC21F43AE736D0A6FE1FDD2,'Status changed from ''Acknowledged'' to ''In Progress''','ST',1657618418,'cr:400051');