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) NULL,
[BedDays] [numeric](18, 0) NULL,
[UserCode] [char](7) NULL,
[ISVirtual] [bit] NULL,
[FirstName] [nvarchar](50) NULL,
[LastName] [nvarchar](50) NULL,
[BeneficiaryName] [nvarchar](50) NULL,
[ReferralDate] [char](10) NULL,
CONSTRAINT [PK_BedriddenBed2] PRIMARY KEY CLUSTERED
(
[ReferralCode] ASC,
[BedDate] ASC,
[BedTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]