declare @pkey int = 1000
select * from zzxrptsc where pkey=@pkey
if exists(select * from zzxrptsc where pkey=@pkey)
	select 'Cannot insert. Pkey '+@pkey+' exists in zzxrptsc.'
else
begin
	begin tran
		insert into zzxrptsc (BATCH_PKEY,CREATED_FOR,ERR_INACTIVE,JOBID,TASK_TIMEOUT,OUTPUT_FILTER,INBOX_XML,TEMPLATE_PKEY,MESSAGE_MODE,PROCESS_GUID,RESUME_FKEY,HOST_NAME,SOURCEMODE,WRITENOTIFICATION,SELECTEDSERVER,TASK_SERVICE,SCHEDULER_PKEY,SERVICE_GUID,RPTNAME,DNEXTEXEC,SHELLDESC,DLASTEXEC,RPTPKEY,CFREQUENCY,DDATE,CTIME,NMINUTES,CMONTH,RPTFILTER,RPTADVFILT,CSTATUS,CACTIVE,NDAYOFMONTH,CDAYOFWEEK,DBEGINNING,DENDING,AUDITLOG,RPTSERVER,PRTCODE,RPTEXPR,TAG,TAG2,RPTORIENT,RPTPAGESIZE,USER_ID,LAST_MOD,PKEY,NOOFCOPIES,CREATED_BY,JOB_TYPE,TASKDESC,RPTEMAIL,RPTFILE,PRTFILE,REMOVEAFTERRUN,BATFLTOVRID,OBR_PARAM,NOTIFY_EMAIL,NOTIFY_WHEN,SVRTYPE,SUPRBAN,rptduplex,NO_RUN_EOM_DAY,RUN_FRI,RUN_MON,RUN_SAT,RUN_SUN,RUN_THU,RUN_TUE,RUN_WED,RUN_WEEK_1,RUN_WEEK_2,RUN_WEEK_3,RUN_WEEK_4,RUN_WEEK_5,RUN_WEEK_6,TASK_TIME_START,TASK_TIME_END)
		values ('-1','CGSADMIN  ','1','SYNC_PROC','60','',null,'0','MSG','9A419005-6216-493E-8896-7E82ACDA594D','0','','II    ','N','                         ','','0',null,'Sync Proc','00:00.0','Sync Proc                               ','00:00.0','9000558','Minutes        ','00:00.0','10:00:00','2','          ','','','READY     ','Y','0','          ','00:00.0','00:00.0','','NET_SCHEDULER            ','ROVMS244  ','','','','-1','-1','CGSADMIN  ','00:00.0','1000','1','CGSADMIN            ','P','SYNC PROC','','',' ','0','N','','','   ','     ','0','0','0','1','1','1','1','1','1','1','1','1','1','1','1','1','12:00 AM','11:59 PM')
		select * from zzxrptsc where pkey=@pkey
	commit tran --rollback
end
select * from zzxrptsc where pkey=@pkey
--check zzxrptsc.Dnextexec<=zzxrptsc.Dending