thanks everybody

also I try this code and this is working fine

insert into diff

select *

from (

select *

from...

hi and thanks

answer of Eirikur's questions

1. Do you have some sample data we can use?

I'm sorry no I do not have

2. Does the code have to detect missing rows?

no code...

I want do this in picture

hi

I try your code but this is not work!!!

no detect deferent row!

yes I want get changed raw in new table

my 3 table struc. is:

CREATE TABLE [dbo].[BedriddenBed2](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[ReferralCode] [char](8) NOT NULL,

[BedDate] [char](10) NOT NULL,

[BedTime] [char](8) NOT NULL,

[BedCode] [char](5)...