Sorry I taught the next image was visible.

please see the data below. consider this as destination. Thanks..

CREATE TABLE [dbo].[testsolddest](

[Weeknumber] [int] NULL,

[customerphone] [char](12) NULL,

[Emailid] [varchar](100) NULL,

[customername] [varchar](50) NULL,

[vidsalesrep] [varchar](50) NULL,

[vidsatco] [char](20)...

based on email id and phone the customer is unique. If the customer changes the order it should only update the product columns which are modified for example internet,video ithg,ba...

Io is same..IOname is different

HI All let me make it more detailed. There are two exits continuously because a person can go to Facility room which is exit and then exit the building which...

HI Livingston

I tested with other employer also it is working find. Thanks for checking.

Thank a Ton for solving this. This looks perfect. 🙂

code starttime ...