Just quickly looking at your problem. Why don't you include the job_id in your user-table, and then left outer join on both the job_id and the run_date and run_time fields....

Try CONVERT(TIMESTAMP, --Your date column--)

and see if that works? I am not too familiar with DB2. So if it doesn't work, my apologies.

Congratulations!

And indeed, thank you for all of your insights over the years.

Lawrence.

It always goes back to the same question, what do we need to accomplish? In some cases CHECKSUM might be a valid option, (I am having a hard time...

Lawrence,

Thanks for taking the time to write this.

I however do not totally agree. While in theory you are correct,

best practise is off course to have a update datetime...

As always my weekend is stacked with fun family outings..

But i will see if i have some time between Kids / basketball and finishing up some work. I will...

sorry for the quick and dirty scripting..

but i quickly recreated something similar, so that i could give you the query.

CREATE TABLE [dbo].[tbl_job](

[jobid] [int] IDENTITY(1,1) NOT NULL,

[person_name] [nvarchar](50) NOT NULL,

[address] [nvarchar](50)...

Blom,

This should do what you need:

Update s

Set s.load_end_dts = dateadd(ss,-1,(GetDate()))

From dbo.s_gebruikers2 as s

Where s.Load_DTS = (SELECT MIN(x.Load_dts) from dbo.s_gebruikers2 x

...

Blom, can you give an example, i am not sure i am following you.

When you say key, what is the key? The subquery as i wrote it down gets the...

Richard, my reply was not directed to you. It was directed towards arjun. Testing would be necessary to determine which method is faster and indeed it all depends.

my previous post...

I dont think that i agree,

More readable? maybe, but more performant? I dont think so.

If you can show where the performance gains are then i wil be more then...

If i understand it correctly,

you want to update to the load_end_dts date

where load_dts is the lowest value and where users have more then entry in the table?

i think...