Here is the data for run_stats_tmp..

SELECT '169519','JOB2','20090903','20090904052513','20090904052528','1','0','ftp_hiteclabs.sh','server1','B' UNION ALL

SELECT '169517','JOB1','20090903','20090904052529','20090904052539','1','0','ftp_hiteclabs.sh','server1','B' UNION ALL

SELECT '169524','JOB7','20090903','20090904052523','20090904052539','1','0','extract_dly_data.sh','server3','B' UNION ALL

SELECT '169522','JOB6','20090903','20090904052513','20090904052522','1','0','extract_dly_data.sh','server3','B' UNION ALL

SELECT '169518','JOB0','20090903','20090904052512','20090904052512','0','0','JOB0','server4','U' UNION ALL

SELECT '169517','JOB1','20090903','20090904052900','20090904052919','2','0','ftp_hiteclabs.sh','server1','B' UNION ALL

SELECT '169523','JOB9','20090903','20090904052731','20090904052741','1','0','extract_dly_data.sh','server3','B' UNION ALL

SELECT '169525','JOB8','20090903','20090904052539','20090904052731','1','0','extract_dly_data.sh','server3','B' UNION ALL

SELECT...

Hi.

No sorry, its not resolved. I was waiting for a reply to a PM about amount of data and attaching files and then providing the data got pushed down the...

I've tried again with/without out begin/commits, ensuring there are pairs and all possible combinations, however if Sergiy is right, then clearly I'm wasting my time and will have to put...

If i don't need a cursor and one of the members can show how, then great.

However, if i have another validation step, wouldn't i negate any improvement in speed and...

Unfortunately, the code is the latest 'incarnation' of attempts. The print statements have changed and I have played around endlessly with begins, rollbacks and commits in trying to get it...

yes, yes, yes to the previous post.

exec update_stats_tst1 (from query analyzer with correct database showing).

exec update_stats_tst1 (from job step - showing the same database in the step)

I am definitely...

Thanks.

Yes, that's exactly right. I've googled handling errors and the code used is from these. I've tried using goto Fail on error, and if not error then continue and just...

Ok yes. Apologies, it was late at night!

Table Def..

CREATE TABLE [dbo].[run_stats] (

[APPLICATION] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[SCHEDTAB] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[GROUPNAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS...