Hi thanks for the reply.

yes you are right i need to use merge... i dont know how to perform that task..

Update records in the actual ebidmanager (not dim)tables (dont forget to update LastUpdateddate for the rows you updated). ( only update the recs that you inserted on Monday)

-- Identify updated...

Oh. Thank you So Much miss.

This is my LoadDetails table and value i enter in it..

Create Table DW_LoadDetails_Ronak

(

LoadID int identity(1,1),

LoadStartTime datetime,

LoadEndtime datetime,

Comments varchar(200)

)

-- 2. insert values

insert into DW_LoadDetails_Ronak (Comments)

values ('Load Status')

insert into...

hi SSCommitted.

I am new in SQL server. i am not much familiar with code. can u explain me the code please ?

Thanks,

Ronak

HI there.

Thanks a lot for your effort. This is what i am looking for...

Thank you very much

hi

thanks a lot for your help.. i rally appreciate it.

THanks again...

Oh Ok.

Thank you Lowell.

Thanks a lot.